Rows to Columns

Question

Hi folks,

The output of my formula component looks like this:

I would like to have my data look like this:

IdRideIdDepartedAt0152041972017-06-09T11:23:43Z1150569582017-06-04T13:50:49Z2150048842017-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-1-quandl/.

I am now using the Text To Columns and Cross Tab components to "turn my data around".

Thanks everybody.

Treyson · Accepted Answer

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