how to split a column ?

[bell_byloli]

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 · Accepted solution]

Like this?

LOAD

:

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

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

:

RESIDENT whatevertable;

Peter

[nilesh_gangurde]

at load time you can create the two more columns

For example:

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

-Nilesh