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

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

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

All comments

Hi @Azimuthmindspace

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

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?

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

@Azimuthmindspace

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

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

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

@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?

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

@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.

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

@Azimuthmindspace

So going back to my original reply:

Group by Move Number. This will return a list of ALL move numbers in your data.
Add a Distinct Count on Terminal, this will return how many unique terminals are associated
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.

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

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

community.xlsx

example.xlsx