Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

ICisneros
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

4 REPLIES 4
saibal_78
8 - Asteroid

Hi

 

Hope attached WF is of any help to you

 

Thanks

danilang
19 - Altair
19 - Altair

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

ICisneros
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.

 

 

ICisneros
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