Add only new data to an existing data table

Help Studio
, ,
1

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.

image
image1083×391 31.9 KB

2

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

Thanks,
Prashant

1 Like
3
4

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

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

1 Like
5

Hi @PRASHANT_GABHANE,

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

1 Like
6

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.

7

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

8

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