Identify duplicate entries

Hi all;

I have a workflow that is allowing me to see the prices of some items. Part of the information I have is the prices and the dates when that prices was valid.(valid from & valid to dates). Is there a way for me to identify if there are duplicate entries for a specific item?

I know that groupby can help me to remove duplicates, but besides removing duplicates I want to check if an item has more than 1 price with different valid dates.

Any thoughts?

Use group by with count on price for the same grouping item.


Thanks! This was very helpful

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.