Grouping data in a list

[#1]

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!

[albertovarela]

You may find this helpful: Don't join - use Applymap instead

[passionate]

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