Hello Automate Community,
Every week, the Sales Engineering team publishes a new 'Tip of the Week' to help you learn something and keep those skills sharp!
This week, I wanted to share a quick reminder about the options available in Query for writing results in to the data file.
Write Records
This option lets you choose how you want Query to write the results in your data file:
Append Data to Result File: Query will start to write new data after the last row of any existing data in the worksheet
Overwrite Data in Result File: Query will overwrite any existing data. However, if downloaded data consists of fewer rows than was in the worksheet, the data in the additional rows will remain. For example, if your worksheet contains 100 rows of data and you run a query that downloads 75 rows of data, the last 25 rows will remain in the sheet.
Clear All Mapped Data from Result File: Starting at the Start Row, Query will clear existing data and write the new downloaded data. Enter a different start row if your data sheet already contains data that you do not want to overwrite.
Note: If you are using a mapping type other than Excel, the 'Overwrite Data in Result File' option is not availlable. Below is an example for Text mapping.
Happy Developing!
Jayasri
------------------------------
Jayasri Varyani
SE
Precisely Software Inc.
------------------------------