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

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

Compare value from multiple excel

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
Highlighted
Meteor

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

Labels