New column with specified cells

[#1]

Hi guys,

I need your help with this. I have a table below as an example.

Year	Brand
2016	Apple
2016	Samsung
2016	Sony
2016	Nokia
2017	Apple
2017	Samsung
2017	Apple
2017	Apple
2017	Nokia
2017	Sony

I need to create a new column with Apple cells only. Maybe like this. Please help me.

Year	New column
2016	Apple
2016	-
2016	-
2016	-
2017	Apple
2017	-
2017	Apple
2017	Apple
2017	-
2017	-

[vinieme12 · Accepted solution]

LOAD

Year

Brand

if(Wildmatch(Brand,'apple'),Brand) as NewCol

From

XXXXX

[passionate]

Hi Peter,

Try using applymap and mapping load:

Newcolumn:

Mapping

LOAD * INLINE [

    Brand, New

    Apple, Apple

];

LOAD Year,

    Brand,

    ApplyMap('Newcolumn',Brand,Null()) as New

FROM

[Sourcedata.xlsx]

(ooxml, embedded labels, table is Sheet2);

Reagards,

Pankaj

[NZFei]

if(Brand='Apple',Brand)

[chinnuchinni]

load

year,

brand,

if (brand='apple',brand,'-') as newapple

from

xxxxx;