Discussion board where members can get started with QlikView.
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.
Go to 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!
What is the mapping logic? As in what is the logic of mapping between Type and 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