Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | - |
LOAD
Year
Brand
if(Wildmatch(Brand,'apple'),Brand) as NewCol
From
XXXXX
LOAD
Year
Brand
if(Wildmatch(Brand,'apple'),Brand) as NewCol
From
XXXXX
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
if(Brand='Apple',Brand)
load
year,
brand,
if (brand='apple',brand,'-') as newapple
from
xxxxx;