Looping Variable To Multiple Output File Names

[jtran]

Scenario Diagram

Hi guys,

I am running into this tricky scenario, need your help or if you can share your experience if it is just relating a bit to this scenario. 

So basically, as shown in the diagram..I have a list of variables namely ContractNo (A1,A2,etc) in the Data Job 1 and I want to push them to the Data Job 2 multiple times in order for for it to produce multiple output files with the file name including the ContractNo at the end. 

I know I should use some sort of looping but due to my limited experience and knowledge, I have no idea where to start. 

[ I am using Dataflux Data Management Studio 2.4]

Thank you so much in advance.

[audrey · Accepted solution]

Hi,

Here's something you can try:

- in your first Data Job, read the lines and count how many you have in an Expression node. User setvar function to save this in a Process Job variable. Write all records to a Worktable.

- use the Global Get/Set node to set an increment counter value to -1

- use the Global Get/Set node to add 1 to this value

- use the If Then node to test if this counter is less than the total number of records

- if yes, read a line from the Worktable and call a Data Job that reads your input file (Contract_%%ContractNo%%.txt) and writes to the output.

- connect this Data Job back to the Global Get/Set node that increments the counter.

I am attaching a zipped version of a test job you can use.

Hope this helps.

Audrey

[jtran]

Thank you so much for your help.
Appreciate for the bonus example 🙂