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.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Basically I have two files, lets call them file A and File B
File A will be an almost weekly document where the people will change each time But will feature their Name and Email.
File B Will rarely if ever change and figures basically the information of everyone in the company, specifically their Email and their Employee ID.
What I want to do is take File A and Search file B for the matching email and when it finds it puts the matching Employee ID number in a new Column in File A.
Mostly the information from File A is coming from a Google Form output so I havent had a chance to go through all of the different google forms(there are like 6) to see how much they match up, but even a basic start of an idea and I could mess with it till it works.