Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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,