How to remove duplicates in a row.

[SudhaGupta1]

How to remove duplicates in a row. If I am using summary tool by grouping then only that particular column will come. I want other columns as it is. How can I do that?

[MilindG]

Normally you would use Unique tool to remove duplicates. Do you have an example dataset or a file?

[SudhaGupta1]

Unique tool is not working in this case. 
Let's take an example with small dataset(Like India there are many rows which are duplicates)-
India 0 0
India 0 2
China 3 7
Japan 4 5

[SudhaGupta1]

Unique tool is not working in this case. 
Let's take an example with small dataset(Like India there are many rows which are duplicates)-
India 0 0
India 0 2
China 3 7
Japan 4 5

[Luke_C]

Hi @SudhaGupta1 

Your india rows are not duplicates, they have different values in the 3rd column. Perhaps you can share what your expected output is?

[cvalteryx · Accepted solution]

Hi @SudhaGupta1 - Can it be assumed that you have 3 columns Country, Field1 and Field2 as below:

Configure the Summarize Tool as below:

Output:

Workflow:

Is this what you were looking for?

[SudhaGupta1]

@cvalteryx  Thanks. I got the result what i was looking for.