Rows to Columns

[RichardRogers]

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.

[Treyson · Accepted 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

[RichardRogers]

Thanks Treyson,

That's very useful, and very helpful with my ongoing education in Alteryx.

Have a great weekend!!!

Richard