Hi folks,
The output of my formula component looks like this:
I would like to have my data look like this:
Id | RideId | DepartedAt |
0 | 15204197 | 2017-06-09T11:23:43Z |
1 | 15056958 | 2017-06-04T13:50:49Z |
2 | 15004884 | 2017-06-02T14:05:16Z |
Would I be able to use the Multi-Row Formula component to accomplish this?
If not, what should I be using?
Thank you for your help,
Richard Rogers
Edit: I read this article: https://www.theinformationlab.co.uk/2015/02/24/grabbing-data-from-web-based-apis-using-alteryx-part-....
I am now using the Text To Columns and Cross Tab components to "turn my data around".
Thanks everybody.
Solved! Go to Solution.
Evening Richard!
Those folks at The Information Lab really know what they are doing! I threw together a little workflow going over your specific problem. I also added a little piece that cleans that date field you have in there as well.
Let me know if you have any questions!
Treyson
Thanks Treyson,
That's very useful, and very helpful with my ongoing education in Alteryx.
Have a great weekend!!!
Richard