Group by Reference Number

[czjames87]

Good morning,

Is there a way to group one reference number by another? I am trying to group pro numbers by their perspective load numbers. I tried using the summarize tool but it doesn't give me an option to group by another reference number. Any help would be greatly appreciated. 

[Jonathan-Sherman]

Hi @czjames87,

Is it possible to give an example of the data sources, with an input and an output you're looking to get to? It'll help us to understand what you're trying to do a little better!

Kind regards,

Jonathan

[mbarone]

Can you give a before and after example of what the incoming data looks like and what you want the outgoing data to look like?

[czjames87]

So the data comes in like this 

What i would like to see is each one of those rows that has multiple pro number be grouped by load number so that when you look at a load number you can see all the pros associated with that load number on a different line. 

[echuong1]

You can do a summarization with a group by on load number, and a concatenation on pro number. You'll need to change pro number to a string prior to doing this.

Once you have your complete list, you can join it back to your complete dataset by load number.