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.
