Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to create multiple parallel jobs for each channels( getting channel id from oracle table) and iterating on each channel_id!

Hi,

I am getting distinct channel_id from oracle table, iterating on each channel_id( saving as a context variable) i am setting the URL value and then hitting the REST API for getting the data based on each channel_id. Please see the below image :- 

 

0683p000009M8i4.png

 

Then setting the URL in tSetGlobalVar --

 

0683p000009M8iD.png

 

This job is takes close to 3 hours, how to make different channel_id run in parallel ??

 

One thing i am doing is using 4 times iterate when fetching values from tFlowtoIterate to tJavaFlex .

 

0683p000009M8hQ.png

 

But When i am fetching the channel_id value from context, later in tmap, its getting wrong channel_id( other columns are correct) may be because context value is changed due to iterate parallel execution.

 

0683p000009M8iI.png

 

The same tmap Columns is going to DB.

Is there any way i can get correct channel_id in my tmap or db ?? 

OR any other way to do parallel execution on channel_id ??

 

Please help !

 

Thanks

Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello,

 

can anyone help me in this, or there is no solution ??

 

Thanks