topic Re: Is there a way to summarize the data like this? in General Discussions

Is there a way to summarize the data like this?

Rachelxyq — Sat, 14 May 2022 22:57:03 GMT

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!

Re: Is there a way to summarize the data like this?

DataNath — Sun, 15 May 2022 01:54:28 GMT

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

Re: Is there a way to summarize the data like this?

Rachelxyq — Sun, 15 May 2022 02:46:16 GMT

Thank you! This is exactly what I need. ^^