Unanswered

Compare a newly created item in both existing and old table

(0) Share

Report

Posted on by brk108

Hi all, I have an old history data and existing data in two Dataverse table. When an item is about to created it must check with old and existing tables if it matches with three columns it must move to new table. So here old history table and existing table contains large volume of data say each contains 2,00,000 rows. What approach I need to follow to compare. Please suggest some ideas

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @brk108 ,

In which table will the new item be created?

Best regards,

Was this reply helpful? Yes No
brk108 68 on at

Like (0)

Report
Copy link

Link copied!

Thinking to create a new table with name Pretable so will push all items into that from there if we compare it will be easy. Please suggest @v-jefferni

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The fewer tables, the better. Could you please explain your business logic? Why there have to be two tables? Why new records need to be compared with the existing data? Generally, we add new records to the existing table, and archive records from existing table to history table if matching some conditions e.g. created in the past year.

Best regards,

Hi @brk108 ,

Was this reply helpful? Yes No
brk108 68 on at

Like (0)

Report
Copy link

Link copied!

In existing Dataverse there is no history data. So we need dump now and check on duplicate items by comparing with existing data and old data while creating since I am using bulk upload in MDA so I am thinking to create a pretable where users will bulk upload data into it and I will schedule a flow it will check every hr .

Was this reply helpful? Yes No