Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Reformatting table

Highlighted
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

Highlighted
8 - Asteroid

How does this look?

Highlighted
12 - Quasar

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