community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Reformatting table

Highlighted
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

Asteroid

How does this look?

Bolide

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