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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
mmctony
Contributor
Contributor

Passing records as a single batch to subjob

Hi,

I'm using TOS and I need to pass records as a batch to a subjob as if, for example, the subjob were reading a single CSV file. However I don't want to use an intermediate file.

 

My first thought is using a Java list in the global map where to put my records into, and then declare a parameter of type Object in the subjob.

 

Are there any better ways? Can this be achived using properly configured components instead of Java code?

 

Thanks in advance,

Mick

Labels (2)
1 Reply
Anonymous
Not applicable

There is a really easy way of doing which also opens up many other possibilities for working with your data.....but it isn't well known. You can use the tHSQLDBOutput and tHSQLDBInput components and load your data into memory. Load it into memory using the tHSQLDBOutput and then read it back (using SQL....so you can filter, join, etc) within your child job.

 

An example is given here.....

 

https://community.talend.com/s/feed/0D75b000005yRDCCA2