We have an excel template which we want to populate. The template has a few rows which need to be skipped while the data is loaded. We are able to do this by defining a name for the header row (key_2) using the formula tool in excel. As shown in the image, the data load has to start from row 5 and key_2 has been defined for the column name in row 4. Then we use the same name while configuring the output tool in alteryx and we are able to load the data in the template. The output option selected is 'Append to existing sheet/file' in the output tool.
What we want to achieve next is we want to reuse the same template for the next data load. To do the same, we deleted all the records inserted in the first run and executed the workflow again with the same configuration of the output tool. We, however, noticed that the next load started from the where the last record ended (row 5 in this case).
How can this be achieved if we want the new records to be loaded from row 5 itself?
