If row has values, then jump down one row and calculate values there

Question

Hi Community!

I have values to add each week into one row across a number of columns. If the row already has values in it, I want Alteryx to go to the row below and retrieve values from another sheet and populate that row.

Any ideas how I can do this?

Many thanks!

Savannah · Answer

Many thanks! I had to add a few more tools, but this helped!

AkimasaKajitani · Answer

You can read input data sheet and history data sheet and union them.

After that overwrite history data sheet.

The image is below.

Please refer attached workflow.

samplewf.yxzp

Savannah · Answer

I'm not sure what you mean, I'm new to Alteryx 🙂 , but I will have a look. Thanks!