Roll up value per account

[#1]

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

[sunny_talwar · Accepted solution]

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)

[#3]

Hi Sunny,

Thank you for your response. This worked

Regards,

Parth