Hey! Is there a possibility to assign table names in a for loop that looks like follows:
for each vSheet in 'A', 'B', 'C'
load F1, F2, F3
(ooxml, embedded labels, table is $(vSheet));
wheras the table names should be different for each of the 3 uploads?
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')
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?