Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

New column with specified cells

Hi guys,

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

YearBrand
2016Apple
2016Samsung
2016Sony
2016Nokia
2017Apple
2017Samsung
2017Apple
2017Apple
2017Nokia
2017Sony

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

YearNew column
2016Apple
2016-
2016-
2016-
2017Apple
2017-
2017Apple
2017Apple
2017-
2017-
1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: New column with specified cells

LOAD

Year

Brand

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

From

XXXXX

4 Replies
vinieme12
Esteemed Contributor II

Re: New column with specified cells

LOAD

Year

Brand

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

From

XXXXX

passionate
Valued Contributor

Re: New column with specified cells

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

xufei123
Valued Contributor

Re: New column with specified cells

if(Brand='Apple',Brand)

chinnuchinni
Contributor III

Re: New column with specified cells

load

year,

brand,

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

from

xxxxx;