topic store load result into variable in QlikView

store load result into variable

didierodayo — Sat, 18 Feb 2017 19:26:55 GMT

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)';

Re: store load result into variable

vinieme12 — Sat, 18 Feb 2017 19:41:07 GMT

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);

Re: store load result into variable

didierodayo — Sat, 18 Feb 2017 20:05:20 GMT

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

Re: store load result into variable

settu_periasamy — Sun, 19 Feb 2017 04:04:50 GMT

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));

Re: store load result into variable

didierodayo — Sun, 19 Feb 2017 05:58:34 GMT

Thanks Settu it worked.