I am trying to store all the previous load result into a variable. Peek() is not working for my scenario because I want al the result in variable. I don't want to use where exists because I will be using the same variable for many loads. How can I achieve this.
table1: LOAD * Inline[ fields 1 2 3 4];
letvMyTableName = peek('fields',0,'table1');
table2: LOADhome FROM (ooxml, embeddedlabels, tableis Sheet1) wherehome = '$(vMyTableName)';