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.
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
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?
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.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |