How to merge new data with old data

[Sra1bandi]

Hi Team,

Need to display new data instead of world data

Old data:-

Description	Class	key	Opening Date	Closing Date	Duration(Days)	Status	Range Request
MIRAVIS 4X5 L                        JPA	SU	284532	28-04-2020			Error	1
AMPLIGO 150 ZC 110X40 ML             UAP	SU	292244	08-10-2020			Error	7360
CRUISER SB EXPORT CLP 200 L          DKA	SU	293504	02-11-2020			Error	1
VENCENDO 20X1 KG                     INA	SU	315322	25-01-2022			Error	13791
VENCENDO 4X5 KG                      INA	SU	315324	25-01-2022			Error	13791
TAMYGIA 20X1 KG                      INA	SU	315325	25-01-2022			Error	13791
TAMYGIA 8X2.5 KG                     INA	SU	315326	25-01-2022			Error	13791
TAMYGIA 4X5 KG                       INA	SU	315327	25-01-2022			Error	13791

New data:-

Description	Class	key	Opening Date	Closing Date	Duration(Days)	Status	Range Request
MIRAVIS 4X5 L                        JPA	SU	284532	28-04-2020	28-04-2020	0	CANCELLED	1
AMPLIGO 150 ZC 110X40 ML             UAP	SU	292244	08-10-2020	08-10-2020	0	CANCELLED	7360
CRUISER SB EXPORT CLP 200 L          DKA	SU	293504	02-11-2020	12-11-2020	8	COMPLETED	1
VENCENDO 20X1 KG                     INA	SU	315322	25-01-2022	18-05-2022	81	COMPLETED	13791
VENCENDO 4X5 KG                      INA	SU	315324	25-01-2022	18-05-2022	81	COMPLETED	13791
TAMYGIA 20X1 KG                      INA	SU	315325	25-01-2022	18-05-2022	81	COMPLETED	13791
TAMYGIA 8X2.5 KG                     INA	SU	315326	25-01-2022	18-05-2022	81	COMPLETED	13791
TAMYGIA 4X5 KG                       INA	SU	315327	25-01-2022	18-05-2022	81	COMPLETED	13791

I need result like below table 

When i am trying to do Concatenate/Join both are showing old and new data i need to replace old data with new data.

Regards,

Sravan.

[Or · Accepted solution]

Perhaps:

Load * From NewData;

Concatenate

Load * From OldData

Where Not Exists(Key);

[Sra1bandi]

Thanks @Or