This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to figure out what would be the best way to solve the below 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
excel file 2
excel file 3
@vrbravo Does the attached workflow answer your question?
hey the files are failed to download.. saying its forbidden ? can you send me the yxmd files ?