Dynamic Loop with Dataflux - it is possible?

[VROUSSAKIS]

Hi all,

I want to create a dynamic loop in Dataflux and I want to ask if is it possible?

The logic that  I want to use is similar with the Data integration Studio logic (Control table - Loop).

First of all I will create a control table with the variables that I want to pass as macro to the loop

Control table e.g.

TABLE NAME      COLUMN

TABLE1                Col1

TABLE1                Col2

.............                ..........

Then I will create two macros variables, the TableName and the Column and then I want to run a job for every raw of the control table.

If it is not possible I will use sas code.

Thanks in advance,

Vassilis

[RonAgresta · Accepted solution]

If you haven't already done so, take a look at process jobs and work tables in Data Management Studio. Process jobs have nodes that let you set macro variables, use conditional logic for loops, fork processes, and run processes in parallel. Work tables can be accessed at this level to provide a mechanism for your control table. Ron

[VROUSSAKIS]

Thank you Ron for your reply.

I manage to loop a job with your information.