topic Re: File Format Issue in QlikView

File Format Issue

qliksus — Tue, 17 Dec 2013 13:46:42 GMT

Hi ,

I have a excel which have data lke

RegionName	RegionCode
A	ABO1 1,AB01 2,AC02 1,DB01 2 etc

No i want the output as

RegionName	Regioncode
A	ABO1 1
A	AB01 2
A	AC02
A	DB01 2
A

Can anyone help me to sorted out?

Thanks in Advance.

Re: File Format Issue

swuehl — Tue, 17 Dec 2013 14:15:29 GMT

Try

LOAD

RegionName,

subfield( RegionCode, ',') as RegionCode

FROM YourTable;

Re: File Format Issue

Tue, 17 Dec 2013 14:33:22 GMT

Hi,

you can do a SubField in the script:

A:

LOAD RegionName,

    RegionCode

FROM

C:\Users\ferrdani\Desktop\Community\Regions.xlsx

(ooxml, embedded labels, table is Sheet1);

B:

NoConcatenate

Load

    RegionName,

    SubField(RegionCode,',') as RegionCode

resident A;

Drop table A

Attached an example

Re: File Format Issue

qliksus — Tue, 17 Dec 2013 14:34:08 GMT

Hi,

I have been using substring function for a long time, but never imagine it can be used without offset which will work as above requirement. Thanks for reminding mine old days to do exercise on functions again.

Thanks.