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

[binuacs]

@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 @binuacs ,

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.

[binuacs · Accepted solution]

@SH_94 One way of doing this