Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

General Discussions

Discuss any topics that are not product-specific here.

How to show duplicates in report

Nagaraju_kanna
8 - Asteroid

Hi,

As per attachement 1 and 2 rows not a duplicate because salary different and 3 and 4 rows are same, report to duplicates based on EMPNO in results.

 

Nagaraju_kanna_0-1650452983446.png

 

 

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

Hi @Nagaraju_kanna 

 

Do a distinct count on salary:

Luke_C_0-1650463175896.png

 

 

Labels