Template Table

Hi Jamie,

I guess we can implement this. But you need to have target tables created in DB with your desired name.

Take a script at the end after the dataflow in the while loop and write sql() function to insert data from temp table created to your Target table.

And write if condition based on the while loop condition you defined.

If suppose you while condition is like this ($G_WHL_COND<=4) and you declared this variable as 1 initially and the value of this will be incremented for every loop.

Now write end script like this for the 1st loop

if($G_WHL_COND=1)

begin

sql('Data_store_name','select * into <tablename> from <temp_table>);

end

for the 2nd loop

if($G_WHL_COND=2)

begin

begin

sql('Data_store_name','select * into <tablename> from <temp_table>);

end

If you want to create 4 tables write if conditions 4 times and for each if condition "From table will be your temp table created in DF" and "into table should be your expected target table name"

Make sure you increment $G_WHL_COND in this script after all the if conditions.

Thanks,

Ravi kiran