topic Convert number to a string in QlikView

Convert number to a string

Wed, 22 Sep 2010 21:40:39 GMT

I want to do something like this

for i=1 to 3
sheet='Sheet' <- here I want sheet to be a 'Sheet1' in first iteration, 'Sheet2' in second etc

LOAD field1,
field2,
field3
FROM

(ooxml, embedded labels, table is $(sheet));
next i

How can i do it?

Convert number to a string

pover — Wed, 22 Sep 2010 23:13:41 GMT

Try this...

for i=1 to 3

let vSheet = 'Sheet$(i)';

LOAD Test
FROM
Book1.xlsx
(ooxml, embedded labels, table is $(vSheet));