SOLVED
Customized Value Set Dynamically
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ankitgupta
7 - Meteor
‎05-23-2019
09:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Dynamic Processing
2 REPLIES 2
Thableaus
17 - Castor
‎05-23-2019
10:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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,
‎05-24-2019
12:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator