Grouping Account in few category

SH_94

Hi Community,

I have few account to be grouped into few category and would like to ask how to build better and dynamic experssion.

Input

Account

1030000

1030200

1039000

1031000

1031010

1031020

1036990

1035000

1038000

1037000

1038001

1034000

Ouput

Account Mapping

1030000 T

1030200 T

1039000 T

1031000 P

1031010 P

1031020 P

1036990 Q

1035000 Q

1038000 R

1037000 K

1038001 K

1034000 M

Thank you in advance

Common Use Cases

Accepted answers

binu_acs

@SH_94 One way of doing this

Mapping_050823.yxmd

All comments

binu_acs

@SH_94 What is the logic for the mapping? For eg: T is mapped to the first three Account numbers, how did you map?

SH_94

Hi @binu_acs ,

It depend on the account.

For example, the logic for Q will be if the account start with 1036 or 1035 series account , then it will be " Q"

Other example , the lofic for P will be if the account start with 1031 series account , then it will be "P"

Other exmaple , the logic for K, there is no specific logic , then it will be 1038001 and 1037000 mapped under "K".

Thank you.

binu_acs

@SH_94 One way of doing this

Mapping_050823.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703