We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎09-13-2023 12:56 AM

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
Reply

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
gawa
16 - Nebula
16 - Nebula
‎09-13-2023 01:45 AM

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

Rearrange data set_gawa.yxmd
Reply
Jack0091
7 - Meteor
‎09-13-2023 02:02 AM

Thank you it works !

Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All