Hi,
I have a dataset which looks like dataset below. And I want to make it similar to output below. Can anyone please help me?
thank you very much in advance. I really appreciate the help!!
(dataset)
(OutPut)
Solved! Go to Solution.
A join tool is equally good. When I have a small number of rows joining to a larger data set, I will tend to use Find-Replace. It has the added advantage of not sorting the data. In this case, it doesn't matter, but if the data was not sorted by the joining column and the sort order was important, then using join would require more work. By the way I noticed I had an inefficiency in my initial workflow -- I could have added both columns with the Find-Replace. I fixed that in the attached.
Great info, @TonyA! Sometimes I need to break out of the DB-mindset and let the Alteryx do the work!
Thank you very much @TonyA and @KP_DML. This worked perfectly. I really appreciate your quick responses!!