Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Reformatting table

murrayjl03
7 - Meteor

Hi!

 

I have a scenario where i have a list of categories and subcategories which appear for various dates, i want to take this data and simplify so i can see of each category/subcategory all the dates that appear in a single cell.

 

Example data:

 

CategorySubcategoryDate
1a30/01/2018 00:00
1c30/01/2018 00:00
1b30/01/2018 00:00
1a27/02/2018 00:00
1c27/02/2018 00:00
1b27/02/2018 00:00
1a27/04/2018 00:00
1c27/04/2018 00:00
1b27/04/2018 00:00
1a30/05/2018 00:00
1c30/05/2018 00:00
1b30/05/2018 00:00
2a30/01/2018 00:00
2c30/01/2018 00:00
2b30/01/2018 00:00
2a27/02/2018 00:00
2c27/02/2018 00:00
2b27/02/2018 00:00
2a27/04/2018 00:00
2c27/04/2018 00:00

 

My desired outcome would show the data like:

 

CategorySubcategoryDate
1a27/02/2018, 27/04/2018, 30/05/2018
1c27/02/2018, 27/04/2018, 30/05/2018
1b27/02/2018, 27/04/2018, 30/05/2018
2a30/01/2018, 27/02/2018, 27/04/2018
2c30/01/2018, 27/02/2018, 27/04/2018
2b30/01/2018, 27/02/2018, 27/04/2018

 

Thanks for any help 🙂

2 REPLIES 2
DataKyle
8 - Asteroid

How does this look?

ChrisTX
15 - Aurora

Use the Summarize tool.  Group by your Category and Subcategory fields.  Select the Date field at the top, then at the bottom choose String > Concatenate.

 

You'll need to strip off your 00:00 time first.

 

Capture.PNG

Labels