We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

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

Compare value from multiple excel

vrbravo
7 - 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
2 REPLIES 2
DiganP
Alteryx Alumni (Retired)

@vrbravo Does the attached workflow answer your question?

Digan
Alteryx
vrbravo
7 - Meteor

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

Labels