Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

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

5 - Atom

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
8 - Asteroid

Hi

 

Hope attached WF is of any help to you

 

Thanks

Highlighted
17 - Castor
17 - 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

Highlighted
5 - Atom

Thank you for your help and sorry for the late response.

 

Your hint help me for another project but not for this specific case (information was mixed up).

The file i share in the forum is a "reduced version". The original file has more data and I couldn't make it work with that file.

 

 

Highlighted
5 - Atom

Thank you for your help and sorry for the late response.

 

Your solution helped me a lot. I just modified some parameters and add 2 additional steps and voila!

 

Thanks mate!

Labels