Data Extraction issue

[Anonymous]

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

[SunilChauhan]

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

[SunilChauhan]

see the attched file

[sujeetsingh]

You can follow the Subfield function concept for your requirement .

[Anonymous]

Hi if i want result as shown in result2 sheet.

thanks for your suggestions...

[SunilChauhan]

see attached file

[renjithpl]

Just an addition to Sunils attachement

[renjithpl]

You can use resident function to sunils's script..