Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Roll up value per account

Hello all,

I would like to create a new column in table where it rolls up to a particular value per account.

All accounts have different support tiers. Some may have more than one type of support tier. I want my newly created column will contain the better support tier per account.

Different types of support tier:

Platinum,

Gold,

Silver,

Basic

For example, if an account has 2 Gold and 1 Platinum, than my newly created column will show Platinum.

For example, if an account has 3 Gold, than my newly created column will show Gold

For example, if an account has 3 Gold and 7 Basic, than my newly created column will show Gold

Please let me know how I can achieve this. Any help is appreciated.

Thank you,

Parth

1 Solution

Accepted Solutions
sunny_talwar

May be provide them with numerical values in the script:

LOAD Dual(SupportTier, Match(SupportTier, 'Basic', 'Silver', 'Gold', 'Platinum')) as SupportTier

and then use MaxString(SupportTier)

View solution in original post

2 Replies
sunny_talwar

May be provide them with numerical values in the script:

LOAD Dual(SupportTier, Match(SupportTier, 'Basic', 'Silver', 'Gold', 'Platinum')) as SupportTier

and then use MaxString(SupportTier)

Not applicable
Author

Hi Sunny,

Thank you for your response. This worked

Regards,

Parth