SOLVED
Date and Rate - Different format output
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
EmilAlteryx01
8 - Asteroid
‎11-22-2024
05:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
HI,
This is my input in excel is the below
TD | VD | Rates | |
Joe | 47107 | 45503 | 0.05 |
Mary | 47289 | 45586 | 0.01 |
Greg | 47289 | 45589 | 0.01 |
Matt | 47472 | 45614 | 0.05 |
Desired Output -
TD | VD | Rates |
2028-12-20 | 2024-07-30 | 500 |
2029-06-20 | 2024-10-21 | 100 |
2029-06-20 | 2024-10-24 | 100 |
2029-12-20 | 2024-11-18 | 500 |
Solved! Go to Solution.
3 REPLIES 3
18 - Pollux
‎11-22-2024
05:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@EmilAlteryx01 This just requires a bit of Formulas - I encourage you to search how to convert Excel numbers into dates as there are many Community articles on this! Here is one example: Excel numeric to Alteryx date - Alteryx Community
Also a multiplier for the rate should be pretty straight forward, just multiply by 100
‎11-22-2024
06:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Castor -- i did try and hunt for an example - this one you attached is perfect.. Issue resolved
18 - Pollux
‎11-22-2024
07:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fantastic - go ahead and mark the response as a solution then!
