topic Re: Using a variable as table name in QlikView

Using a variable as table name

dirk1955 — Mon, 09 Sep 2013 19:48:22 GMT

Hi,

I wonder if it is possible to use a variable as a table name.

Explanation, i have a lot of reportings and i would love to ad a variable to a tabel name.

vDate = 20130901

the table name from the file is [IZ] and i would love to rename the table name like this $(vDate) IZ

Anyone?

THX in advance.

Re: Using a variable as table name

swuehl — Mon, 09 Sep 2013 19:53:53 GMT

Yes ,should not be a big problem. Have you tried something like

[$(vDate) IZ]:

Load ... From ...;

Re: Using a variable as table name

Mon, 09 Sep 2013 20:01:49 GMT

Hi,

Yes you can use variable as table name. See the below script:

SalesIV:

LOAD * INLINE [
Dept, Name, Sales
Inventory, A, 10
Inventory, B, 15
Inventory, D, 2
Sales, A, 14
Sales, C, 30
];

set vtabname = 'Sales';

Test:

NoConcatenate

load

Dept

Resident

$(vtabname)IV;

Hope this help,

Anosh