topic Re: Mapping data with its category in QlikView

Mapping data with its category

Jacob — Sat, 16 Nov 2024 03:48:18 GMT

Hi all,

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

Excel data Source

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 — Sat, 20 Apr 2019 09:13:04 GMT

Hi,

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

Jacob — Sat, 20 Apr 2019 10:08:04 GMT

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 — Sat, 20 Apr 2019 10:27:19 GMT

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 — Sat, 20 Apr 2019 12:50:04 GMT

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

arpitkharkia — Sat, 20 Apr 2019 15:38:17 GMT

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!