alteryx

[Mina2021]

Hello,

I am very new to alteryx.

I am creating a workflow where I have some rows with blank values and need to copy each blank row value from the above row. 

I need to put row 2's values in row 3 & 4, row 5's values in row 6 and row 7's values in row 8.

I have attached the data set.

Kindly help!

[AngelosPachis · Accepted solution]

Hi @Mina2021 ,

The easiest way to do that is with a multi-row formula tool. That tool will check if there is a value in the current cell, and if not it will get the value from the cell above. 

However, because you want to do that for more than one of the 172 columns you have in your dataset, the easiest way to achieve that is bringing your data to a thinner format, converting the columns you need to apply the multi-row formula tool into rows.

Then, once the values have been populated correctly, you can bring them back to the original structure your table use to have.

Hope that helps,

Angelos

[Mina2021]

Hi @AngelosPachis, 

Thank you so much! This is helpful.

[AngelosPachis]

No worries @Mina2021 ,

Feel free to post any question in the community, there are many people willing to help.