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: 
sumanta12
Creator II
Creator II

Need help for Automation instead of manual work

Hi 

Could you please help me by using loop:

LET vFirstField = FieldName(1,'CT_TMP');
LET vFirstFieldVerticalDim = PEEK('VFieldName',0,'VDims'); 

LET vFirstField1 = FieldName(2,'CT_TMP');
LET vFirstFieldVerticalDim1 = PEEK('VFieldName',1,'VDims');

LET vFirstField2 = FieldName(3,'CT_TMP');
LET vFirstFieldVerticalDim2 = PEEK('VFieldName',2,'VDims');

-------- likewise it will continue when a new field will be added in the source.

CT:
LOAD

$(vFirstField)                    AS   $(vFirstFieldVerticalDim),
$(vFirstField1)                   AS   $(vFirstFieldVerticalDim1),
$(vFirstField2)                   AS   $(vFirstFieldVerticalDim2)

---------------------------------  Likewise it will continue.
Resident CT_TMP;

Labels (2)
1 Reply
Kushal_Chawda

Not clear what you want to do. Can you please elaborate on your requirement