Right now, I have two different data sets that I am trying to recombine. One has a multitude of different columns one of which is a concatenation of two of the columns in the data set. The other data set has the same concatenation , some other columns and a column called entry type. All that I want to do is combine the two data sets based on the concatenation column so that I essentially just add on the entry type column to the first data set. However the issue that I'm having is that in the first data set, the concatenation appears multiple times while the second data set is grouped by them, so each concatenation only appears once. Essentially, this is just a VLOOKUP but i'm not sure how to do that in Alteryx. Any and all help is immensely appreciated!
