Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps:
Load * From NewData;
Concatenate
Load * From OldData
Where Not Exists(Key);
Perhaps:
Load * From NewData;
Concatenate
Load * From OldData
Where Not Exists(Key);
Thanks @Or