Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
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