I want to write data from the source file to the target Excel File. However, I want to check the data and write it to the next empty line. The output is as in the image.
The source excel is dynamic. Every time I run it, it will change and be written to the target excel.
1 Like
Just use append range activity…it would automatically write to the next available empty cell
Cheers
1 Like
Append Range Workbook will work. It will just append the data from the next found empty line to the already written workbook with some data.
Regards
1 Like
Source:
Destination before updating
=> Read Range Workbbok source file
Output-> dt
=> Append Range Workbook dt
Regards
1 Like
Sorry for replying late.
But in my project, I did the reading with the “Read Range” activity. Then I used the “Filter data Table” activity. “Append range” does not work here.
1 Like
That is not the issue. It works, you just need to pass the output of filter data table activity to append range activity. Filter data table is your source dt right? If yes it will works
Regards,
1 Like
Append Range Workbook will not cause any problem. Since after filteration of data you will have a new datatable right, you can pass that datatable variable and pass the file name of destination file in Append Range Workbook. Please specify if you get Source Excel as per your screenshot after filteration. If yes, it will work without any errors.
Regards
1 Like
in filter are you removing any columns …if not then there would not be any issue
cheers
1 Like
Hi Anil,
I’m not removing any columns in the filter.
I transfer the data exactly as it is. But it is rewritten from scratch every time.
as per your screenshot also we can see the data is appended what issue are you seeing in it?
cheers
Hi,
The output image was created manually. There is a User List in column D. Sorry, column D is not visible. Since the user list is full, when I use the append range activity, it continues to write from the end of the table (A23). However
I want it to be written in cell A9, which is the first empty row. I add the new image.
