topic Re: Data Extraction issue in QlikView

Data Extraction issue

Anonymous — Wed, 10 Dec 2014 04:58:19 GMT

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 — Wed, 10 Dec 2014 05:12:09 GMT

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 — Wed, 10 Dec 2014 05:14:46 GMT

see the attched file

sujeetsingh — Wed, 10 Dec 2014 05:24:34 GMT

You can follow the Subfield function concept for your requirement .

Anonymous — Wed, 10 Dec 2014 05:33:39 GMT

Hi if i want result as shown in result2 sheet.

thanks for your suggestions...

SunilChauhan — Wed, 10 Dec 2014 05:36:39 GMT

see attached file

renjithpl — Wed, 10 Dec 2014 05:42:25 GMT

Just an addition to Sunils attachement

renjithpl — Wed, 10 Dec 2014 05:43:21 GMT

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