In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Rearrange data set

Jack0091
7 - Meteor

Hello I have the following data set

FROM_DATETO_DATEFROM TOPRICE
2023-01-012023-01-311160.345
2023-01-012023-01-31161250.234
2023-01-012023-01-31251400.646
2023-01-012023-01-31401600.423
2023-01-012023-01-316019999.874
2022-08-152022-12-311160.765
2022-08-152022-12-31161250.324
2022-08-152022-12-31251400.545
2022-08-152022-12-31401600.762
2022-08-152022-12-316019999.927

 

I would like to rearrange it to look like this

FROM_DATETO_DATE1160250400600
2023-01-012023-01-31.345.234.646 .423.874
2022-08-152022-12-31.765.324.545762.927
2 REPLIES 2
gawa
16 - Nebula
16 - Nebula

Hi @Jack0091 

 

Simply you can just use Cross Tab tool. Please refer to the attached workflow. If you have further query, please let me know.

image.png

Jack0091
7 - Meteor

Thank you it works !

Labels
Top Solution Authors