Find Out Unique Value based on condition

Question

Hi

I want to find out unique value taking date and employee ID into consideration.

But out of duplicates rows I want only that row which has value in comment column not the empty one.

I can find out unique by the help of unique tool but not able to get it with one extra condition.

Attaching sample file for reference.

Thanks in advance.

Unique Value Sample File.xlsx

CarliE · Accepted Answer

@sgaryali

What you will need to do is sort before using the unique tool -- make sure to sort comments descending to ensure the comment field with data in it is listed first. The FIRST unique value will be taken. This should solve the issue.

If this was helpful make sure to mark it as a solution. If I am reading this wrong, can you elaborate a little more?

Thanks,

phottovy · Accepted Answer

Hi @sgaryali ,

I believe if you place a sort tool before your unique tool and set it up like this, it will keep the one with the comment. This would not work if there were multiple rows with comments though:

IraWatt · Accepted Answer

Hey @sgaryali,

You can use this configuration with the summarize: