Mapping data with its category

[Jacob]

Hi all,

I have to column one is TYPE and CATEGORY and i want to map type with category .

Excel data Source

Type	Category
10	category1
20	category1
40	category2
30	category1
60	category3
70	category3
80	category2
90	category2

I tried doing this using IF condition .

IF(wildmatch(Type,'10'), 'category1') as xyz

and also dont want to use pick function.

but i have N number of records to map. There is any other alternative to achieve this.

[arpitkharkia]

Hi,

What is the mapping logic? As in what is the logic of mapping between Type and Category?

[Jacob]

its simple.
if value is 10,20,30 it will fall in category1
if value is 40,80,90 it will fall in category2

[arpitkharkia]

Im not sure i understood your issue completely, but there multiple are ways of doing,

1. Use nested if statement.

2. Create a mapping file in excel and join accordingly

[Jacob]

2. Create a mapping file in excel and join accordingly
can you plz provide any link . how to map excel

[arpitkharkia · Accepted solution]

Im sorry i dont have any link that i can provide. You can follow the steps:

1. Create a mapping file in excel.

2. Load the file in your qvf.

3.  Left join this table to the table you need the category.

I hope this help!