Using match to select specific items and renaming

[#1]

Hello,

How do I match to specific item on my dimension. also wanna collate some item together and name them as one. see...

=if(match([item text], 'Blocks', 'Buckets', 'Box',

             if(match([item text], 'Cutlass', 'Plates','Spoon'), 'Cutlery'),[Item text]),
'Cloth','Table','Chair'.........''

),[item text])

I wanna collate cutlass, plate, spoon to one name. what so I do?

[hic]

Use a mapping table. See Data Cleansing

HIC

[sunny_talwar]

Not sure what you are trying to do? May be this in your load statement:

If(Match([item text], 'Cutlass', 'Plates', 'Spoon'), 'Cutlery', [item text]) as New_Item_Text

[maxgro]

z:

load

  [item text],

  if(match([item text], 'Blocks', 'Buckets', 'Box',), '????',

  if(match([item text], 'Cutlass', 'Plates','Spoon'), 'Cutlery',

  [item text]

  )) as [new item text]

inline [

item text

Blocks

Buckets

Box

Cutlass

Plates

Spoon

Chair

];

[jonathandienst]

You can do this:

=If(Match([item text], 'Blocks', 'Buckets'), 'Box',

If(Match([item text], 'Cutlass', 'Plates','Spoon'), 'Cutlery',

If(Match([item text], 'Cloth','Table','Chair'), 'Furniture')))

But I would create an mapping table that loads the category associated with the items, and then use the category as the dimension.

[Anonymous]

You can use an excel file or an inline table to load the category to the corresponding item.

Load it as a mapping table then use the applymap function in your destination table.

[#7]

Its a nested IF statement. I already matched to pick specific fields and I need to call these items A name. so that is where the next IF statement comes in

[#8]

Am coding in Dimension editor not load please. I have a field holding all the items I wanna match

[#9]

No that's not what I want

[#10]

How do I do nested IF here

IF(Match(Country, 'Great Britain','UNITED KINGDOM','UK'), 'United Kingdom', Country)