Editing a dataset

[vchauhan011]

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)

[TonyA · Accepted solution]

This is a tough one to answer without understanding what you are trying to do. I have a workflow attached that populates the second column based on the info in the first three rows and then sets the last equal to the first. Is this what you have in mind?

[KP_DML]

Hello,

I did similar to @TonyA but used a join after splitting the lookup and data values.

[TonyA]

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.

[KP_DML]

Great info, @TonyA! Sometimes I need to break out of the DB-mindset and let the Alteryx do the work!

[vchauhan011]

Thank you very much  @TonyA  and @KP_DML. This worked perfectly. I really appreciate your quick responses!!