Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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
Luminary Alumni
Luminary Alumni

Try this...

for i=1 to 3

let vSheet = 'Sheet$(i)';

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

next