How to selectively read value as variable or as a literal
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’
v_ID3= ‘333’
v_ID4= ‘444’
v_ID5= $(v_ID1),$(v_ID2),$(v_ID3)
My script is like this:
Test: LOAD Type, Variable, $(vVariableValue)//NOTE I do have this variabalized but for the input file examples sake I kept just one example to keep it simpler FROM '..\includes\File1.xlsx' (ooxml, embeddedlabels, tableis Sheet1) ;