Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Deleting Rows with Duplicate Hierarcy

mittuldoshi
5 - Atom

I have an alteryx WF which generates the below hierarchy, currently it is limited to 4 hierarhy but this can increase to 10. What I am unable to do is how I can delete the rows where the hierarchy is getting repeated. 

 

For e.g. In the below I only need 1st 3 rows to be there, rest everything is a repeat, Row 1 record, X > Y > Z > A the hierarchy is getting repeated in Row 6

similarly Row2 is similar to Row4 and so on. So basically if the Level 2 > 3 > 4 record appears again in Level 1 > 2 > 3 then it should be deleted. 

 

Tried multi row formula does not work as sorting the fields in Level 1 > Level 2 > Level 3 > Level 4 order will not result in the rows coming exactly in the prior row. 

 

RecordLevel 1Level 2Level 3Level 4
1XYZA
2ABC 
3ADE 
4BC  
5DE  
6YZA 
7ZA  
1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@mittuldoshi 
We can use a Transpose tool and then use multi-row tool.

Capture1A.PNG

Labels
Top Solution Authors