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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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