Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to make the following code work but it errors out with error stating Garbage at the end of line. Please advise:
Let z=']';
test:
load * inline [zField
'$(z)'];
HI
Try like this
Let z=']';
Tst:
Load * Inline
[
Col1,Col2,Col3
RO_0001,S1,4/15/2010
RO_0001,S2,3/19/2012
RO_0001,S2,1/10/2011
RO_0002,S2,3/25/2010
RO_0002,S2,8/8/2012
RO_0002,S1,10/10/2019
RO_0003,S1,12/12/2009
RO_0003,S2,10/01/2012
RO_0003,S2,06/05/2011
RO_0003,S2,05/05/2009
$(z) Where Col2='S2';
Hope it helps