Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an excel file which has a column for lines of businesses. In that column I have 12 different values; however, when the data loads into Qlikview, I want to reclassify the list into 5 major lines of business. For example:
Original Source | Desired Qlikview Grouping |
Asset Management | AM |
Asset & Wealth Management | AM |
Chief Operating Office | CIB |
Chief Investment Office | CIB |
Commercial Bank | CCB |
Consumer and Community Bank | CCB |
Corporate & Investment Bank | Corporate |
Corporate Aligned | Corporate |
Corporate Staff | Corporate |
External | Corporate |
Private Equity | Equity |
Total Private Equity | Equity |
Can I do this from the script? And/or, after loading the list?
Any help is appreciated, thank you!
You may find this helpful: Don't join - use Applymap instead
Hi Azdar,
You can achieve this by:
1. ApplyMap
2. Replace Function in Load Script
3. Using Match as suggested by Kay But, Modify Using Pick Match rather than If.
Regards,
Pankaj