community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Compare value from multiple excel

Highlighted
Meteor

Hello,

 

I am trying to figure out what would be the best way to solve the below scenario. 

 

Scenario:

 

In the below sample tables  File1 has rank 1 , file 2 has rank 2 and file 3 has rank 3.  Rank here means priority

Rules to follow 

1) Now, i have 101 in all three files. However i need to pick 101 from FILE 1 only as it has Rank 1.

2)  105 is not in file 1 but present in File 2 and file 3 . So as per priority i need to pick only in File 2 not File 3 .

 

 

The final output should have all the col A value and exclude the record which is not picked due to priority.

example there should be only row of 101 and it should come from file 1 

 

 

how should i approach this problem in alteryx.  Any guidance is greatly appreciated.

 

excel file 1 

 

AB
1011
1022
1034
1045

 

excel file 2 

 

AB
1014
1052
1061
1074

 

 

excel file 3 

 

AB
10110
1052
1081
1094
Alteryx
Alteryx

@vrbravo Does the attached workflow answer your question?

Digan
Alteryx
Meteor

hey the files are failed to download.. saying its forbidden ? can you send me the yxmd files ?

Labels