Hello everyone,
I really need help from the great community
In the PJ file, I have a dashboard tab "TDB" where there is information, I want to update (replace) them according to the "UPDATE" tab.
Except that my problem is the following: in the base file "TDB" I have ID TRADE NAME which represents a key between the two files except that I cannot use search V because there are duplications of lines and that the table join creates too many excess rows.
Have you ever had to deal with this type of case?
Many thanks for your help
A.K. Spoiler (Highlight to read) "TDB"
Nom Prénom id tade date d'entrée de le portefeuille Pays type TEST0 TEST7 B97383 10/10/2023 FR TYPE 1 TEST2 TEST6 B427667 11/10/2023 ES TYPE 1 TEST6 TEST6 B673667 12/10/2023 UK TYPE 3 TEST6 TEST2 B512009 13/10/2023 USA TYPE 1 TEST6 TEST2 B512009 13/10/2023 USA TYPE 1 TEST4 TEST9 B699089 14/10/2023 IR TYPE 1 TEST4 TEST9 B699089 14/10/2023 TK TYPE 1 TEST5 TEST8 C418393 15/10/2023 IT TYPE 3 TEST3 TEST9 C650815 16/10/2023 FA TYPE 1 TEST5 TEST3 C305766 17/10/2023 FR TYPE 1 TEST5 TEST3 C305766 17/10/2023 SP TYPE 1 TEST0 TEST7 C912205 18/10/2023 ES TYPE 3 TEST4 TEST3 C908759 19/10/2023 UK TYPE 1 TEST3 TEST2 C644895 20/10/2023 USA TYPE 1 TEST6 TEST10 C510078 21/10/2023 MA TYPE 3 TEST9 TEST5 C987474 22/10/2023 IT TYPE 1 TEST9 TEST3 C526980 23/10/2023 FA TYPE 3 TEST10 TEST0 C607672 24/10/2023 RA TYPE 2
"MAJ"
id tade date d'entrée de le portefeuille Pays type B97383 10/10/2023 FR TYPE 1 B427667 20/12/2022 IT TYPE 1 B673667 21/12/2022 DZ TYPE 3 B512009 13/10/2023 USA TYPE 1 B699089 14/10/2023 MA TYPE 1 C418393 15/10/2023 IT TYPE 3 C650815 16/10/2023 FA TYPE 1 C305766 17/10/2023 FR TYPE 1 C912205 18/10/2023 ES TYPE 3 C908759 19/10/2023 UK TYPE 1 C644895 20/10/2023 USA TYPE 1 C510078 21/10/2023 MA TYPE 3 C987474 22/10/2023 IT TYPE 1 C526980 23/10/2023 FA TYPE 3 C607672 24/10/2023 RA TYPE 2 B699089 14/10/2023 BA TYPE 1 B699089 14/10/2023 BO TYPE 1 B699089 14/10/2023 BC TYPE 1
"TDB"Nom Prénom id tadedate d'entrée de le portefeuillePaystypeTEST0TEST7B9738310/10/2023FRTYPE 1TEST2TEST6B42766711/10/2023ESTYPE 1TEST6TEST6B67366712/10/2023UKTYPE 3TEST6TEST2B51200913/10/2023USATYPE 1TEST6TEST2B51200913/10/2023USATYPE 1TEST4TEST9B69908914/10/2023IRTYPE 1TEST4TEST9B69908914/10/2023TKTYPE 1TEST5TEST8C41839315/10/2023ITTYPE 3TEST3TEST9C65081516/10/2023FATYPE 1TEST5TEST3C30576617/10/2023FRTYPE 1TEST5TEST3C30576617/10/2023SPTYPE 1TEST0TEST7C91220518/10/2023ESTYPE 3TEST4TEST3C90875919/10/2023UKTYPE 1TEST3TEST2C64489520/10/2023USATYPE 1TEST6TEST10C51007821/10/2023MATYPE 3TEST9TEST5C98747422/10/2023ITTYPE 1TEST9TEST3C52698023/10/2023FATYPE 3TEST10TEST0C60767224/10/2023RATYPE 2"MAJ"id tadedate d'entrée de le portefeuillePaystypeB9738310/10/2023FRTYPE 1B42766720/12/2022ITTYPE 1B67366721/12/2022DZTYPE 3B51200913/10/2023USATYPE 1B69908914/10/2023MATYPE 1C41839315/10/2023ITTYPE 3C65081516/10/2023FATYPE 1C30576617/10/2023FRTYPE 1C91220518/10/2023ESTYPE 3C90875919/10/2023UKTYPE 1C64489520/10/2023USATYPE 1C51007821/10/2023MATYPE 3C98747422/10/2023ITTYPE 1C52698023/10/2023FATYPE 3C60767224/10/2023RATYPE 2B69908914/10/2023BATYPE 1B69908914/10/2023BOTYPE 1B69908914/10/2023BCTYPE 1
