Assign table names in a for loop

[berstrom]

Hey! Is there a possibility to assign table names in a for loop that looks like follows:

for each vSheet in 'A', 'B', 'C'

[Table Name]:

load F1, F2, F3

from [data.xlsx]
(ooxml, embedded labels, table is $(vSheet));

next;

wheras the table names should be different for each of the 3 uploads?

Best regards

[jfkinspari]

Well, you should get 1 table named the first parameter in the if() and two tables named the second parameter. 

Be careful with concatenation

[Brett_Bleess]

Have a look at the following Design Blog post, might help clarify the conversation you have been having:

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

Regards,
Brett