Transpose or CrossTab - Not working?

Ahmad_S

Hi Team,

I have a small query and I am trying to fix the issue since last 1 day:

Current Data Structure:

Month | 01-01-20202 | 02-01-2020 | ....

App 1 | Event | No Event | ...

App 2 | Event | No Event | ...

Desired Data Structure:

Month | App 1 | App 2

01-01-2020 | ...

02-01-2020 | ...

It is change the dates in one column while the application name into other.

Appreciate if anyone from the community can help.

Regards

Output

Accepted answers

AbhilashR

Hi @Ahmad_S, I have attempted to transpose your data based on how I interpret your dataset and requirement. Give this a try on your larger dataset and let us know if you run into challenges or if this isn't what you were looking for.

sample.yxmd

All comments

ChrisTX

These posts may help:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-or-cross-tab-help/m-p/376063#M69008

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-Question/m-p/345557#M63103

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Merge-rows-per-header/m-p/370022#M67955

Cndro_Consulting

You can use transpose or crosstab to achieve this, probably you will need a text to column tool too.Can you mock up some data so I can understand you better? @Ahmad_S

AbhilashR

sample.yxmd

Cndro_Consulting

This is awesome @AbhilashR

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167