Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
eromiyasimon
Creator II
Creator II

I want to pass all the field values into diffent variables !

TableA:

LOAD * Inline [
Data1,Data2,Data3,swap
A1,A2,A3,one
B1,B2,B3,two
C1,C2,C3,three
D1,D2,D3,four
];


SUB:
Load
swap as datalabel
Resident TableA;

For x=0 to 3

let Datalable$(x)=peek('datalabel');

NEXT

TRACE $(Datalable0);
TRACE $(Datalable1);
TRACE $(Datalable2);
TRACE $(Datalable3);

exit Script;

 

eromiyasimon_0-1696593498717.png

instead of all four, i want one,two,three,four vice versa 

Labels (1)
1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

You need to use more parameters for the Peek() function:

let Datalable$(x)=peek('datalabel', x, 'SUB');

Cheers,

View solution in original post

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

You need to use more parameters for the Peek() function:

let Datalable$(x)=peek('datalabel', x, 'SUB');

Cheers,