Customized Value Set Dynamically

[ankitgupta]

Hi All, I am trying to solve one scenario and seeking help...

I have a data set like below, 

Name	Value
201710	1
201711	2
201712	3
201801	4
201802	5
201803	6

Output that I am looking for is below, a new column is required which sets 201710 as 201710_Y1_M1, 201711_Y2_M2 (2017 is a special case as my product launched in this year in month 10 so I want to call it as Y1_M1. Rest will go from M1 to M12 each year

Name	Value	Name_New
201710	1	201710_Y1_M1
201711	2	201711_Y1_M2
201712	3	201712_Y1_M3
201801	4	201801_Y2_M1
201802	5	201802_Y2_M2
201803	6	201803_Y2_M3

[Thableaus · Accepted solution]

Hi @ankitgupta 

Using Tile Tool you have a simple solution:

- Use Formula Tool to get the year

- Use Tile Tool to get a sequenced order

- Use Formula Tool again to set up your field

WF attached.

Cheers,

[ankitgupta]

Thanks a ton @Thableaus 

-Ankit