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 have a similar question to the above, but takes it one step further. I have two files that I am trying to compare, but need to reference two columns in one file to multiple columns in another file.
File 1 includes a list of companies and the year we did work with them. File 2 is the “key” of what priority tier they were in in the respective year. I would like to pull in the relevant Priority Tier from the relevant year.
I was able to build the Alteryx flow shown above, but cant quite figure out how to do this one.