Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
i am not able to fetch data from one file as that is encrypted one. please help me to fetch it.
please check attached file. Actual sheet contain data i have and result sheet contains result i want.
Thanks,
Ankit
try this
Test:
Load ID,
subfield(CODE,',',1) as CODE,subfield(Value ,',',1) as Value
from path
Concatenate
Load ID,
subfield(CODE,',',2) as CODE,subfield(Value ,',',2) as Value
from path
Concatenate
Load ID,
subfield(CODE,',',3) as CODE,subfield(Value ,',',3) as Value
from path
see the attched file
You can follow the Subfield function concept for your requirement .
Hi if i want result as shown in result2 sheet.
thanks for your suggestions...
see attached file
Just an addition to Sunils attachement
You can use resident function to sunils's script..