Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Identify Duplicate rows across multiple columns

Data_Alter
8 - Asteroid

I have the data below where I want to identify duplicate journals. The fields "Account" , "Account Number" and "Amount" need to be same for a journal to be same. For e.g

  • The journals 1, 2, 4 and 5 are same. 
  • 3 and 6 are same
  • 7 and 8 are unique

 

Journal NumberAccountAccount numberAmount
1Revenue1000-100
1Debtors2000120
1VAT3000-20
2Revenue1000-100
2Debtors2000120
2VAT3000-20
3COS150050
3Creditors1600-50
4Revenue1000-100
4Debtors2000120
4VAT3000-20
5Revenue1000-100
5Debtors2000120
5VAT3000-20
6COS150050
6Creditors1600-50
7Cash1000120
7Debtors2000120
8Revenue1000-60
8Debtors200080
8VAT3000-20

 

I want the result to look like below

Journal NumberAccountAccount numberAmountNumber of occurrences
1Revenue1000-1004
1Debtors20001204
1VAT3000-204
2Revenue1000-1004
2Debtors20001204
2VAT3000-204
3COS1500502
3Creditors1600-502
4Revenue1000-1004
4Debtors20001204
4VAT3000-204
5Revenue1000-1004
5Debtors20001204
5VAT3000-204
6COS1500502
6Creditors1600-502
7Cash10001201
7Debtors20001201
8Revenue1000-601
8Debtors2000801
8VAT3000-201
5 REPLIES 5
mceleavey
17 - Castor
17 - Castor

Hi @Data_Alter ,

 

This is relatively straightforward but I think your numbers are incorrect. As you can see in the image below of your data, you have this combination as 4 when I can see 5 combinations:

 

mceleavey_0-1605224746818.png

The workflow is as follows:

 

mceleavey_1-1605224769694.png

The workflow is attached.

 

I hope this helps.

 

M.

 



Bulien

Qiu
20 - Arcturus
20 - Arcturus

@Data_Alter 

Hope this is the one you need.

1113-Takkarstar.PNG

Hi @Data_Alter 

 

Please check this one out. Nice challenge! Cheers!

 

christine_assaad_0-1605225616054.png

 

Data_Alter
8 - Asteroid

Thanks looks great 👍🏻👍🏻👍🏻😊

Qiu
20 - Arcturus
20 - Arcturus

@Data_Alter 

Thank you for the accept mark!

Labels