Add only new data to an existing data table

Add only new data to an existing data table

I already have data scraped from the web in sheet1 of Google Spreadsheet, and I want to add only the new data that is not in the existing data table to sheet1 by scraping in daily job.

How can I solve this problem?

I am thinking of writing the scraped data to sheet2 in daily job and then write only the new sheet2 data to sheet1.

Hi @rsugimura
You can use join datable activity to achieve this.


1 Like

dtFirst.AsEnumerable.Any(Function (row) row.Equals(currentRow))

Use this in for each row of your datatable ==>dtSecond

1 Like


Thank you.
I thought I could not use this Join Data Table for Google Spreadsheets, but I could. it was solved.

1 Like

Hi @Divyanshu_Divyanshu ,

Thanks for the reply.
This is the first syntax I’ve seen and I wasn’t sure how to use it.
This time I solved it with Join Data Tables, but what kind of activities should I use it in? If you have any online help, I’d be glad to know.

if you are familiar with lambda expression in any other language it works same.
Let me know if you need further help

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.