Transform Data - Transpose + Cross-Tab?

[Nico711]

Hi,

I'm new to Alteryx and I'm having trouble figuring out how to transform data downloaded via an API into a proper format. I need dates in a column on the left and data points associated with said dates in columns to the right. The date is labeled as list.X.date and the associated data points are labeled list.X.Y. My workflow is attached. I think I need to use Transpose and/or Cross-Tab tools, but I can't figure it out. Any help you can provide would be much appreciated.

Thanks!

[JosephSerpis · Accepted solution]

Hi @Nico711 I mocked up a workflow that should help you. Let me know what you think?

[CKP · Accepted solution]

Hi @Nico711 

I believe this gets you to the result you're looking for.

[DavidP · Accepted solution]

Does this work for you?