topic How to parse single field into multiple in QlikView

How to parse single field into multiple

Tue, 14 Jul 2015 20:33:55 GMT

If I have a field in excel called Matter and data looks as follows:

ABC_PAT_Trademark_test

How can I parse group into a different field?

So ABC would be Seg

PAT would be Sub

Trademark would be type

and test would be LOC

swuehl — Tue, 14 Jul 2015 20:35:12 GMT

LOAD

subfield(Matter,'_',1) as Seg,

subfield(Matter,'_',2) as Sub,

subfield(Matter,'_',3) as type,

subfield(Matter,'_',4) as LOC,

...

FROM ...;