Question Re: Script to Call a Data Flow in a loop using a Process in CPI-DS in Technology Q&A

Script to Call a Data Flow in a loop using a Process in CPI-DS

aourzy_ankur — Fri, 17 Dec 2021 18:03:33 GMT

I would like to write a script to increment value of a Global Parameter by 1 and when it reaches a number say 10 then Stop the process further.

How do I frame my script ?

Re: Script to Call a Data Flow in a loop using a Process in CPI-DS

former_member786268 — Tue, 25 Jan 2022 12:21:04 GMT

Global Variable: $G_TIME_LOOP , integer, initial value = 1

Script Before dataflow:
print('Loop number = ' || $G_TIME_LOOP);

Script After:

IF
($G_TIME_LOOP = 10)
begin
print('Loop finish number = ' || $G_TIME_LOOP);
raise_exception_ext('JOB FINISH', 0);
end
else
begin

$G_TIME_LOOP = $G_TIME_LOOP+1;
end;

Re: Script to Call a Data Flow in a loop using a Process in CPI-DS

aourzy_ankur — Fri, 17 Jun 2022 05:14:11 GMT

Thankyou Alexey that eased my work to quite a bit. I am able to optimise not one but many tasks.

Re: Script to Call a Data Flow in a loop using a Process in CPI-DS

former_member594071 — Mon, 20 Jun 2022 10:00:00 GMT

Hi nikhaenko,

It would be really helpful if you could help me with this scenario. I am trying to achieve the same by following your syntax however I am not getting the results as expected. The process is running but not getting into the loop. It ends without even executing the dataflow once.

Thanks

Shubham

Re: Script to Call a Data Flow in a loop using a Process in CPI-DS

balazsbence95 — Mon, 20 Jun 2022 10:47:11 GMT

Hi shubham54498,

I cannot see any function provided that is capable of re-executing the task in a postload script.
The functions are listed here.

What you may try is using the exec() function to execute a command that triggers a task execution via runTask SOAP web service function. But somebody else here in this Community might have a better and sophisticated best practice for that.

Regards,
Bence

Re: Script to Call a Data Flow in a loop using a Process in CPI-DS

sapsujit — Sat, 21 Oct 2023 02:12:48 GMT

Could you tell me if this looping works? and share some screenshot of log how it looks.

Re: Script to Call a Data Flow in a loop using a Process in CPI-DS

kendw17 — Fri, 16 Aug 2024 13:31:15 GMT

I tried a similar loop going from -1 to 0. It should have created two files. One with last months data and one with this months data. It ran for 1 second and produced no print message or files. Did you create the process with three flows in a circle does work?

Re: Script to Call a Data Flow in a loop using a Process in CPI-DS

kendw17 — Fri, 16 Aug 2024 14:17:46 GMT

I created a new process and copied script 1 and script 2 exactly from above. The process started and finished without any print statement in the log or calling my data flow.