topic Using variables in a For... Loop in QlikView

Using variables in a For... Loop

Wed, 15 Feb 2012 16:15:46 GMT

I am trying to load data from several data sources that is in identical format in each source. Each time I load the data I need to tag it with the product type. The file name to load from and the product type to tag the data with are stored as a variables. I want to be able to loop through my load code for the various variable names.

So for each of the multiple product types I want to load the following code, using variables varProduct1, varFile1, varProduct2, varFile2, varProduct3...

TableX:

Add LOAD

$(varProduct1) as Product,

FROM

[$(varFile1)]

(biff, embedded labels, header is 1 lines, table is ProdData$);

Something like -

For a = 1 to 9

TableX:

Add LOAD

$('varProduct'&$(a)) as Product,

FROM

[$('varFile'&$(a))]

(biff, embedded labels, header is 1 lines, table is ProdData$);

Next a

However QlikView doesn't like $('varProduct'&$(a)) or $('varFile'&$(a)). Is it possible to string together text and a variable value and get QlikView to recognise it as a variable?

Using variables in a For... Loop

CELAMBARASAN — Wed, 15 Feb 2012 16:20:37 GMT

hi,

use it like this.

For a = 1 to 9

TableX:

Add LOAD

'varProduct'&$(a) as Product,

FROM

['varFile'&$(a)]

(biff, embedded labels, header is 1 lines, table is ProdData$);

Next a

No need to use strings within dollar expansions.

Celambarasan

Using variables in a For... Loop

Wed, 15 Feb 2012 16:24:31 GMT

Thank you!

I also managed to use this (without ampersand):

For a = 1 to 9

TableX:

Add LOAD

'$(varProduct$(a))' as Product,

FROM

[$(varFile$(a))]

(biff, embedded labels, header is 1 lines, table is ProdData$);

Next a