topic Re: how to split a column ? in QlikView

how to split a column ?

bell_byloli — Tue, 28 Jan 2014 12:47:08 GMT

how to split a column while doing a data load,

the column name "Category"

phone Accessories

Screen Modules

phone Units

charger Modules

No Product Category

charger Units

cable Units

i want to split this column into two, where one column contains only items ending with 'Units'.

Peter_Cammaert — Tue, 28 Jan 2014 12:52:45 GMT

Like this?

LOAD

if (wildmatch(Category, '*Units'), Category) AS CategoryA,

if (Not wildmatch(Category, '*Units'), Category) AS CategoryB,

RESIDENT whatevertable;

Peter

nilesh_gangurde — Tue, 28 Jan 2014 12:53:38 GMT

at load time you can create the two more columns

For example:

if (wildmatch(Category,'*Units') , Category,'NULL') as NEW_FIELD

-Nilesh