if the data contains one move number and multiple and different terminals

[Azimuthmindspace]

A transportation company in Canada trying to find out if one move number has more than one terminal ID, 

I am trying to find out if one move number has more than one terminal ID, I am kind of stuck as I know I should use the Formula tool but I am quite confused about the expression to be used for the result. 

I would require an assist on this.

[Luke_C]

@Azimuthmindspace Is that different than what we're describing? I'm sorry but I truly don't understand. Count Distinct is the function that will tell you how many different (and unique!) terminals there are for a given move number. 

[Azimuthmindspace]

move number 1802354 was just an example  so I used that number and searched it and wanted to show you what I have and trying to explain what I am trying to do if any move number has more than one and different terminals 

[Luke_C]

@Azimuthmindspace 

So going back to my original reply: 

1. Group by Move Number. This will return a list of ALL move numbers in your data.
2. Add a Distinct Count on Terminal, this will return how many unique terminals are associated
3. Filter on Distinct Count >1. The T anchor will show you ALL of the move numbers with more than one terminal

Please share your data, expected result, and the workflow you built if that doesn't work. 

[ChrisTX]

your question: so if I want to only get data of move numbers having more than one and different shipper or terminals how can do it

my question: did Count Unique not return the correct answer?

Please post a sample workflow, and more extensive sample input and expected output.

Chris

[Azimuthmindspace]

my Question again 

to find out "if there is a move number that has more than one shipper ID and these Shipper IDs happened to be different (NOT SAME).

how can I create a report where it only shows move numbers having more than one shipper ID and that is different? 

Doing the method where I group the move number and count the shipper doesn't provide the result I am looking for.

I have attached data below (community contains data) and the example contains my question.

so if 1802354 is the move number it says here that 1802354 has more than 1 shipper ID and these Shipper IDs are having Different Names

I have used the search function to get the example data and I typed in the move number on the search tab and it shows what is the result I am looking for any move number having more than 1 Shipper ID and these shipper ID names are different.

move Number 1802354 has two shipper IDs one is SHEAMIO and another one is PETOAK

[ChrisTX · Accepted solution]

Is the attached workflow what you're looking for?

Is Count Distinct giving the correct result, but you just need additional tools to get the final output format you want?

Chris