Hello,
I need to have the dates in chronological order within a row. The row can have from 1 to 8 different dates. Current state and desired state examples attached.
Thank you,
Kim
No worries @kas,
As a learning opportunity for me, do you have data that you tried it with that broke my workflow?I used your 19 rows from the example data source and it worked for all of them. One note: Right after I first posted, I noticed I hadn't turned your dates into Date types and that this threw off the sort. I fixed the workflow and reposted (also attached again)
Does your workflow of mine have the newly added DateTime tool?
Just curious, Thanks for your help!
Brad
Hi @kas,
How about this? See my attached workflow for specific steps.
Let me know if you have any questions!
Thanks!
@kas,
Here's one way to accomplish that:
Hello@BradWerner ,
Close, but not quite, it only did it in the first 10 rows (up to 3 billing dates), after that it falls apart.
Hello @john_miller9
Unfortunately I'm on an older version of Alteryx and am unable to import your workflow.
I'm on Version 2019.3.5.17947
