topic Re: Assign table names in a for loop in QlikView

Assign table names in a for loop

berstrom — Sat, 16 Nov 2024 03:03:20 GMT

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

Re: Assign table names in a for loop

acsaggar — Tue, 09 Jul 2019 16:11:01 GMT

simply use the for loop variable?

e.g.

$(vSheet):

load F1,F2,F3

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

next;

Re: Assign table names in a for loop

acsaggar — Tue, 09 Jul 2019 18:44:54 GMT

also make sure you use noconcatenate if you want distinct tables

Re: Assign table names in a for loop

berstrom — Wed, 10 Jul 2019 06:42:33 GMT

Thanks for the answer, but is there also a way in using a table name other than the loop variable?

Re: Assign table names in a for loop

jfkinspari — Wed, 10 Jul 2019 07:07:30 GMT

Sure, you could calculate the label in a variable, and use that.

e.g. LET TableLabel = IF($(vSheet) = 'A', 'New Label', 'Label for B and C')

$(TableLabel):
Load...

Re: Assign table names in a for loop

berstrom — Wed, 10 Jul 2019 10:10:37 GMT

Thanks for the answer, but now I get for all tables the new name that I assigned to A even for B and C. The table names look like that:

'NewLabel', 'NewLabel-1', 'NewLabel-2'

Any idea why I the IF statement doesn't work as required?

Re: Assign table names in a for loop

jfkinspari — Wed, 10 Jul 2019 10:07:01 GMT

How does your if() look?

Re: Assign table names in a for loop

berstrom — Wed, 10 Jul 2019 10:25:59 GMT

Basically as yours I think:

if($(vSheet) = 'A', 'NewA', 'NewBC')

Re: Assign table names in a for loop

jfkinspari — Wed, 10 Jul 2019 11:01:47 GMT

The variable vSheet does might not need the $() expansion.

if(vSheet = 'A', 'NewA', 'NewBC')

Re: Assign table names in a for loop

berstrom — Wed, 10 Jul 2019 11:13:56 GMT

This results in the same problem as before with the difference that its now happening with 'NewBC'

Re: Assign table names in a for loop

jfkinspari — Wed, 10 Jul 2019 11:27:50 GMT

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

Be careful with concatenation

Re: Assign table names in a for loop

Brett_Bleess — Wed, 31 Jul 2019 19:05:55 GMT

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