Could make little more clearly?

Matillion ETL
1

Hi @JoeCommunityManager

It's good to hear from you. I have previously referred the Excel Query Component and came to an idea but still I can't find the solution for it.

My doubt is before loading a data into main table I want to confirm it whether the data already present in main table if it present the should only update if the data is new then it should append.Is there any idea to this.

I have attached the previous discusion of this topic below

Previous question and answer link:

https://community.matillion.com/s/feed/0D5Tm000007QhXgKAK

,
2

Thank you for your reply @HariRamK​

I am taking a look into this, just to confirm I have understood this correctly.

You want to check the main table of data and when loading new data want to ensure only the new data is added to the main table?

Kind regards, Joe

3

Yeah @JoeCommunityManager​ thanks for the reply. Before loading data, the data needs to be checked in the main table,

If the data already exist in the main table any changes with new data, the old data should need to be updated. then the data is totaly new it should be append or insert into the main table.