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]

You can do a

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

If(Match(Country, 'Paris','Bretagne'), 'France'))

Just make sure that you have the same number of right-brackets in the end as you have If()-functions.

HIC

PS But a mapping table is MUCH better...

[hic]

I guess you are using this in a calculated dimension. If so, you might need to wrap in in Aggr() function (which is kind of like a for-next loop):

=Aggr(

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

          If(Match(Country, 'Paris','Bretagne'), 'France')),

     Country)

HIC

[#4]

Mapping table? Make me understand

[sunny_talwar]

Mapping load information can be found here as well:

http://www.learnqlickview.com/a-qlikview-tutorial-mapping-load-in-qlikview/

[hic]

See Data Cleansing