Add only new data to an existing data table

[rsugimura (RintaroSugimura)]

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.

[PRASHANT_GABHANE]

@rsugimura

I already h

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

Thanks,
Prashant

[PRASHANT_GABHANE]

Join Data Tables

[Divyanshu_Divyanshu]

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

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

[rsugimura (RintaroSugimura)]

Hi @PRASHANT_GABHANE,

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

[rsugimura (RintaroSugimura)]

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.

[Divyanshu_Divyanshu]

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