How to update a date from Excel to a Fraction in Alteryx

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!

Input

Date Time

Accepted answers

danilang

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

DateToQty.yxmd

All comments

neilgallen

A formula tool using Datetimeformat along with datetimeparse is a likely answer here. The field is likely a string, so we need to parse the relevant parts and then build back up in a particular format.

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.

danilang

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

DateToQty.yxmd

jstaker

This performed the function I needed to change the date back to a fraction.

Thank you @danilang and @neilgallen

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703