I am trying to have some values read as literals while others should be replace by the variable value.
Example Input file:
So when I do this the first four ID’s come as I want which is literal. However I want the fifth one to show as ‘111’,’222’,’333’
Variable Output I Get
v_ID1 = ‘111’
v_ID2 = ‘222’
My script is like this:
$(vVariableValue) //NOTE I do have this variabalized but for the input file examples sake I kept just one example to keep it simpler
(ooxml, embedded labels, table is Sheet1) ;
LET vNumberofRows = NoOfRows ('Test');
For vI = 0 to (vNumberofRows - 1);
LET vVariable= Peek('Variable',vI,'Test');
LET vValue= Peek ('$(vVariableValue)',vI,'Test');
LET [$(vVariable)] = Peek ('$(vVariableValue)', vI, 'Test') ;
Do I Need to do some sort of IF logic inside of the loop to treat these differently?
I just can’t seem to get the syntax to work
Also note, I am trying to do this without minimal changing of the source excel file format.