I have an excel sheet as shown below
But I am looking to modify it as shown below
As you can see, I am trying to add a new column(“View”) to the datatable and each row of column view has a set of values which will repeat every day when I run the script.
Please note that I will be running this script daily to append data. So currently the screenshots has 3 rows for today, but tomorrow it will be 6 rows
How can I do this? I can add a new column with default value for each row but how do I approach this scneario
You can approach this Scenario as below:
Create a Excel File “Output” with “View” Column (If not created).
Read the Excel File without View Column.
Add Column “View” in DataTable.
Append the DataTable in the Excel File “Output”.
@Santan_Barnwal, Fixed this using merge data table and append range activities. Thanks for your prompt response. Appreciate it
But how do I avoid headers while appending data? Every time, it appends the headers as well. There is no “Add Headers” option to disable as well
To avoid repeat.
First create a new excel/csv file.
Then you ll need to use new datatable (with View column) to append the data to excel/csv and clear the same datatable after each append activity.
To avoid headers in consecutive runs:
check if the new file exists, if yes use append activity. if no, create file with headers.