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;
