Hi all,
Can any one Explain the below code how it works?
My data has two fileds in excel
LOAD ColorNo,
ColorCode
FROM
[C\...\....\ColorCodes.xlsx]
(ooxml, embedded labels, table is Sheet1);
Let vNumberOfRows = NoOfRows('ColorCodes');
For vI = 0 to (vNumberOfRows - 1)
Let vVariable_Name = Peek('ColorNo',vI,'Expression');
Let [$(vVariable_Name)] = Peek('ColorCode',vI,'Expression');
Next
DROP Table ColorCodes;
