Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Jacob
New Contributor II

Mapping data with its category

Hi all,

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

Excel data Source

TypeCategory
10category1
20category1
40category2
30category1
60category3
70category3
80category2
90category2

 

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.

  

 

Labels (3)
1 Solution

Accepted Solutions
arpitkharkia
Contributor III

Re: Mapping data with its category

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!

5 Replies
arpitkharkia
Contributor III

Re: Mapping data with its category

Hi,

 

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

Jacob
New Contributor II

Re: Mapping data with its category

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
Contributor III

Re: Mapping data with its category

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
New Contributor II

Re: Mapping data with its category

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

Re: Mapping data with its category

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!