store load result into variable

[didierodayo]

Hello,

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.

Thanks

table1:
LOAD * Inline [
fields
1
2
3
4];

let vMyTableName = peek('fields',0,'table1');

table2:
LOAD home
FROM
(ooxml, embedded labels, table is Sheet1) where home = '$(vMyTableName)';

[vinieme12]

try without quotes, single quotes is use for comparing strings

table1:
LOAD * Inline [
fields
1
2
3
4];

let vMyTableName = peek('fields',0,'table1');

table2:
LOAD home
FROM
(ooxml, embedded labels, table is Sheet1) where home = $(vMyTableName);

[didierodayo]

I have.  The problem is that I want to store all the values from table1 into the variable.  Not just 1 value.

In my case table 1 could have both numbers and string.

Thanks

[settu_periasamy · Accepted solution]

May be try this..

table1:
LOAD Concat(chr(39)&fields&chr(39),',') as fields;
LOAD * Inline [
fields
1
a
3
c];

let vMyTableName = peek('fields',0,'table1');
DROP Table table1;

table2:
LOAD * INLINE [
Dim
1
2
3
4
5
a
b
c
] Where Match(Dim,$(vMyTableName));

[didierodayo]

Thanks Settu it worked.