How to update a date from Excel to a Fraction in Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I bet I am not the only one that has struggled with this, but I cannot find any answers when searching the community. I have workflow that uses a CSV input - the CSV automatically updates a column called "pack size" to a date before inputted into Alteryx. The pack size is really a fraction like "6/4" which represents 6 boxes with 4 units.
See snip below:
How can I reverse the date function of the CSV? I want to see "6/4" not JUN 4.
After I get the fraction back in the field I would also like to separate the field where the "/" is and multiply the two numbers together to make the field "24". I appreciate any help you all can provide!
Thanks, Jordan!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In this case:
datetimeformat(datetimeparse([PACK],”%d-%B”),”%m/%d)
The parse takes the string and identifies which parts are months and dates, and then formats the date in the desired manner using datetimeformat.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jstaker
Building on @neilgallen's suggestion, here's a workflow that converts the date to a fraction and then performs the final multiplication you need
Giving
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This performed the function I needed to change the date back to a fraction.
Thank you @danilang and @neilgallen