Group by Reference Number

Question

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.

echuong1 · Answer

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.

New Workflow23.yxmd

czjames87 · Answer

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.

mbarone · Answer

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?