Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert number to a string

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?

1 Reply
pover
Partner - Master
Partner - Master

Try this...

for i=1 to 3

let vSheet = 'Sheet$(i)';

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

next