Is there a way to summarize the data like this?

Question

Hi!

I have a table contains Order Shipment Date, Invoice Number and Tracking Number.

We only have the Quantity information in Invoice Number level. In order to get the quantity number for each order, we would like Tracking Numbers to be in one cell for each Invoice Number.

Is there a way in Alteryx to do that?

Thanks!

Alteryx Question.xlsx

DataNath · Accepted Answer

Very simple to do with Alteryx! A summarize tool will do that, using the following configuration (workflow attached):

You also mentioned measuring quantity by placing them on 1 line so I have also added an extra 'count' column on the end in case that helps!

On a side note: It took me a while to see this as it's posted in the 'General' section - for troubleshooting/Designer help see: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/bd-p/designer-discussions