Hi
Just to take note
column Position to Email
column Criteria to Date
column Date Effective to Status
Each of these column are belong to a datatable from the web when scraping.
However when i write into csv , column Criteria to Date uses more than a single row.
The end result i wanted is to feed all info in a single row from column Position to Status.
oh I see the the cause problem, this is because in the writing process between “Position to Email” and “Criteria Criteria to Date” and “column Date Effective to Status”
you do it in a separate process in partial write activity or saving diferent datatable , is that right ?
you have to combine the “Position to Email” column and “Criteria to Date column” and “column Date Effective to Status” in one datatable variable, then you can use write range / write to csv.
so the data will be on the same line without a gap.
dont write your column wirh partial , you need to combine first. because you wirte it with partial, thats column will be write on new line.
if you are willing, you can send the xaml code so I can check
if you want to not use datatable manipulation, I can give advice, don’t use append to range excel activity, or append the line csv
You should be use excel write to range activities from each block of the column, by listing the correct range,