topic Re: Assigning dynamic table name in For Loop in QlikView

Assigning dynamic table name in For Loop

Anonymous — Sun, 08 May 2016 20:41:42 GMT

Hi,

Is it possible to assign dynamic tables based on changing numeric values in the for loop ?

Please refer to the sample code below:

For i = 1 to 12

TableName & $(i):

LOAD *

RESIDENT

Next i;

Re: Assigning dynamic table name in For Loop

tamilarasu — Mon, 09 May 2016 04:09:10 GMT

Hi Sudhakaran,

Yes. We can assign dynamic table names. Check the below script.

For i = 1 to 4

Qualify '*';

[TableName $(i)]:
Load
  AddMonths(today(),12) - recno() AS Date
Autogenerate (AddMonths(today(),12) - MakeDate(2016,01,01));

Next i;

Re: Assigning dynamic table name in For Loop

Kushal_Chawda — Mon, 09 May 2016 05:41:07 GMT

what do you mean by assigning dynamic table name? what is requirement? why you want to do that?

Re: Assigning dynamic table name in For Loop

Anonymous — Mon, 09 May 2016 14:35:50 GMT

Hi Kushal,

There are multiple reasons why this approach is needed:

1. To load separate monthly tables, and load them into separate QVDs

2. Avoid the recursive load of all data to be concatenated into a single table.

2. Process data for different months differently (this is where it is easier when we have different table names for each month)

Hope this helps.