Append filter and append datatable

Help Studio
, ,
1

Hello guys,

I have 2 query

  1. I have an excel it should write the data only column “Comments” containing “Proceed” to sheet1

image
image498×656 19.7 KB

So after the process completed Excel looks like this

image

2 ) If i reran the process it should take the data which contain proceed in comment column and append to this sheet1 and it should not duplicate.

Forum Engagement Daily Reports
2

Hii @Gokul_Murali ,

  1. You can use filter data table to read the column “Comments” containing “Proceed” and use write range to write the data into sheet1

Find the attachment for your reference

image

2.You can use remove duplicate activity before writing the data into the excel

or you can use this syntax

dt_RemoveDuplicates = dt_Filtered.DefaultView.ToTable(True)

Regards,

3

I done it the thing is that it is overwriting the data which is already exist.

image
image567×531 9.25 KB

See i rerun the process the status column will be replaced.

4

@Gokul_Murali,

Does input varies from each run?

If this is the case and you are using the same output excel to write the data it will overwrite the existing data.

Possible solution to overcome this

  1. use different output excel or different sheet to write the data
  2. or else use append range to append the data to Existing output excel file

Thanks,

5

Hi @Gokul_Murali ,

Use the filer datatable to filter the column based on ur value ,
Now use lookupdatatable for a unique value to verify if already exists
If exists ignore
If not exists write back

Regards
AutomationXbyKiran