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.
Hello all, learning Tableau as we speak and have run into a snag in one of my training exercises.
Step 1. I have a Data "Key" where Project and Project Group contain the "Same" data, but the Project Group column has some spelling/formatting corrections that fix issues in the Project column. (i.e. Project Column= COGS, Project Group= C.O.G.S. without the .'s)
Step 2. I have a large database file with nearly 7k lines of data that includes the Project Column.
- - What I'd like to do is Join the two inputs, and have the Database file do a Vlookup (Alteryx equivalent to excel) on the "Project" column in my database file to make sure it has all instances of the project included (from Key); and then create an output Project Column on my database file for every single instance.
Please let me know if this is possible! Thank you!
I'd post an example, but you can actually look at examples in your Alteryx Designer by right clicking the tool and clicking 'Open Example'. Most of the basic tools have that-- it's a pretty great resource.