topic Re: Seperating a field in QlikView

Seperating a field

mccook — Thu, 18 Sep 2014 10:11:21 GMT

Hi,

I have a field with contents like below:

Field 1

90200|19871162|O1|1.000|17.000

1100|203332121|O3|16.000|1.000

The results I am after are (creating separate fields and removing the
pipes):

Field 1 Field 2 Field 3 Field 4 Field 5

90200 19871162 O1 1.000 17.000

1100 203332121 O3 16.000 1.000

Any help appreciated

Cheers,

Dean

Re: Seperating a field

MK_QSL — Thu, 18 Sep 2014 10:13:29 GMT

Load

SubField([Field 1],'|',1) as [Field 1],

SubField([Field 1],'|',2) as [Field 2],

SubField([Field 1],'|',3) as [Field 3],

SubField([Field 1],'|',4) as [Field 4],

SubField([Field 1],'|',5) as [Field 5]

Inline

[

Field 1

90200|19871162|O1|1.000|17.000

1100|203332121|O3|16.000|1.000

];

Re: Seperating a field

anbu1984 — Thu, 18 Sep 2014 10:14:09 GMT

Load

SubField(Txt,'|',1) As Field1,SubField(Txt,'|',2) As Field2 ... Inline [

Txt

90200|19871162|O1|1.000|17.000

1100|203332121|O3|16.000|1.000 ] ;

Re: Seperating a field

er_mohit — Thu, 18 Sep 2014 10:14:20 GMT

Hi use subfield function

Like this

load *,subfield(Field,'|',1) as Field1, subfield(Field,'|',2) as Field2,subfield(Field,'|',3) as Field3,

subfield(Field,'|',4) as Field4,subfield(Field,'|',5) as Field5,inline [

Field

90200|19871162|O1|1.000|17.000

1100|203332121|O3|16.000|1.000

];

hope it helps

Re: Seperating a field

Thu, 18 Sep 2014 10:15:09 GMT

Hi,

Use can use Subfield to achieve this...

Re: Seperating a field

MarcoWedel — Thu, 18 Sep 2014 15:55:17 GMT

Hi,

another solution could be:

Generic
LOAD ID,
    'Field '&AutoNumber(RowNo(),ID) as FieldName,
    Field;
LOAD RecNo() as ID,
    SubField([Field 1],'|') as Field
INLINE [
    Field 1
    90200|19871162|O1|1.000|17.000
    1100|203332121|O3|16.000|1.000
];

hope this helps

regards

Marco