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]

Hi @Azimuthmindspace 

Use the Summarize Tool. Group by Move Number and Count Distinct Terminal ID. Then Filter Count >1.

[ChrisTX]

For the Summarize tool, use Count Distinct

Using this sample data:

Move Number	Terminal ID
A	1
A	2
A	1
B	3
B	3
C	3
C	2
C	1
D	1

the result is:

Chris

[IraWatt]

Hey @Azimuthmindspace, do you have any example data?

[Azimuthmindspace]

thanks, what if it is one move number has more than one and different terminals 

[Luke_C]

@Azimuthmindspace 

Count Distinct returns the count of distinct (unique) terminals associated with the move number. Please attach sample data and your desired output.

[ChrisTX]

For this request: "to find out if one move number has more than one terminal ID" ...  use Count Distinct

I don't understand this question: "what if it is one move number has more than one and different terminals"

As @Luke_C mentioned, please attach sample input and expected output.

Chris

[Azimuthmindspace]

the Move number is 1802354 and this move number has more than one shipper or Terminal (this is an example) so if I want to only get data of move numbers having more than one and different shipper or terminals how can do it 

here the move number is 1802354 and this move as two terminals one is "SHEHAMIO" and another one is "PETOAK" 

so I am trying to find from the data if there is more than one terminal for the same Move number 

[Luke_C]

@Azimuthmindspace What does your desired output look like?

The summarize tool should result in 1802354 having a distinct count of 2. That tells you there's two different terminals on the move number. Now what? Do you want to concatenate the terminals into one cell? Do you want an if statement to say Yes or No? 

[Azimuthmindspace]

No i am trying to find if any move number has more than one and different terminals