Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

How to copy values between cells when 2 or more conditions are meet

Highlighted

I am trying to merge row information when values in different columns meet between them...

Here is a picture of what I am trying to accomplish.

Would be great if you can give me a hand with this!

 

Help.jpg

Thank you in advance

Highlighted
Asteroid

Hi

 

Hope attached WF is of any help to you

 

Thanks

Castor
Castor

Hi @ICisneros 

 

This is a tricky little problem that can be solved by transposing your data and applying the proper sort order before using a Multi-row tool to replace missing data values with the value from the previous row.  Use a Sample tool to extract the values from only one of the duplicated rows and cross tab to get the original table back.   

 

w.png

The first few rows of the output look like this

r.png

 

Dan

Labels