Greetings,
When you say split it up - you mean you want the script to pick up later and
run records 2000 to x?
To have a script jump to a step based on a record number.there are several
ways to do this.
This is one that also illustrates a helpful "trick" - how to make one rule
act like it has more than one Goto.
1. Create a Step (you'll need to "goto" this step at a logical point
in your script - probably after you get the next record from the file
2. Add a Rule to it (condition Always)
3. In the Action use:
If D.record = 2000 then
Step = "GEN Report"
Exit sub
Else
Step ="Where to go if d.record is < 2000
Exit sub
End if
If you want this to work .J
It is VERY important to use Exit sub - and not have a Goto on this Rule.
I can extend this trick to have more than 2 Gotos -and could use either if
then / else or Select Case:
Here's an example of using Select Case in a Rules' Action..
Select Case True
Case A=B
Step="A equaled B"
Exit Sub
Case B=C
Step="B equaled C"
Exit Sub
Case Thom="Hopefully didn't confuse anyone"
Step="Successful Answer"
Exit Sub
Case Else
Step="Call Support for further clarification
Exit Sub
End select
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com <http://www.bossoft.com/>
Sign <http://www.bostonworkstation.com/customer_center/special_events.aspx>
up for my weekly webinar!
LEGAL NOTICE Unless expressly stated otherwise, this message is confidential
and may be privileged. It is intended for the addressee(s) only. Access to
this E-mail by anyone else is unauthorized. If you are not an addressee, any
disclosure or copying of the contents of this E-mail or any action taken (or
not taken) in reliance on it is unauthorized and may be unlawful. If you are
not an addressee, please inform the sender immediately, then delete this
message and empty from your trash.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Walker, Reese
Sent: Tuesday, May 20, 2008 4:11 PM
To: [email protected]
Subject: [Talk] Record time out
I have a large excel file (14000 records) I am processing in STAR. I know
that I can't complete it all in one day so I want to split it up, but I also
want to the report to generate daily for the entire file. How do I tell the
data station to run until D.record = 2000 and then go to step "GEN Report"?
Thanks,
Reese
Reese E. Walker
Financial Systems Analyst
Phoebe Putney Memorial Hospital
Albany, GA. 31702
Phone: (229) 312-4259
Pager: (229) 431-7658
Fax: (229) 312-4316
_____
Disclaimer:
The HIPAA Final Privacy Rule requires covered entities to safeguard
certain Protected Health Information (PHI) related to a person's
healthcare. Information being faxed to you may include PHI after
appropriate authorization from the patient or under circumstances
that do not require patient authorization. You, the recipient, are
obligated to maintain PHI in a safe and secure manner. You may not
re-disclose without additional patient consent or as required by
law. Unauthorized re-disclosure or failure to safeguard PHI could
subject you to penalties described in federal (HIPAA) and state
law. If you the reader of this message are not the intended
recipient, or the employee or agent responsible to deliver it to
the intended recipient, please notify us immediately and destroy
the related message.
