Alteryx Designer Desktop Discussions

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

Output Data to last row in a column

Travis_Ratliff
8 - Asteroid

Hello All,

 

I have attached my sample workflow and output file. I am able to get my workflow to successfully update the cell F4. However, I am unsure how to do the other 4 outputs. What I would like is to always output to the last row of columns A-D respectively. For example, this month the workflow would output to A56-D56 and next month it would output to A57-D57.

 

Any help/tips/tricks are greatly appreciated.

1 REPLY 1
jbravman_
8 - Asteroid

Input your existing data - > count records -> formulate the range you're going to write too - > write that specific data to the file. 

ie: i append existing data and new data - > count records - > formulate range -> output specific range. 

Labels
Top Solution Authors