In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date and Rate - Different format output

EmilAlteryx01
8 - Asteroid

HI,

This is my input in excel is the below

 TDVDRates
Joe 47107455030.05
Mary47289455860.01
Greg47289455890.01
Matt47472456140.05

 

Desired Output - 

TDVDRates
2028-12-202024-07-30500
2029-06-202024-10-21100
2029-06-202024-10-24100
2029-12-202024-11-18500
3 REPLIES 3
alexnajm
18 - Pollux
18 - Pollux

@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

EmilAlteryx01
8 - Asteroid

Thanks Castor -- i did try and hunt for an example - this one you attached is perfect.. Issue resolved 

alexnajm
18 - Pollux
18 - Pollux

Fantastic - go ahead and mark the response as a solution then!

Labels
Top Solution Authors