I hope you can help me out please.
I have a Datatable with 3 columns (the first one is the name of the society taking from another Excel datatable ; the second will find the name used in the App Coala and if there is no name ; the third column provides it), like following
Society|Name_Coala|name_Manual
sky|SKY|
Shop | | SHOPPING
abcd|ABC|
I need the find the good name of the Society. Which means that from a list created previously, I take the first society name and I have to check if in the datatable, i found the NAme_Coala, if empty, I take the name from the third column.
Can anyone help me ? I have tryied with a lookup activity but it was too long and i don’t think that it is the right way to do so.
If i was’nt clear, please let me know.
ah yes sorry.
dt1 is the Datatable from the first Excel where I took the list of the Societies.
Then I read the Dt2 (dt with the 3 columns) in there, i try to collect the right name of the society) and I need to write this right name into the dt1, where i have added a new column for this.
For example, in my list of societies (taking from an excel file), I have the Amazone Compagny. But in my Coala application, where i need to find the Amazone compagny, it can happen that in the database of this app, it will be written SARL Amazone (so not exactly the same naming).
That is why I need, first, to collect the right name (from this datatable 2, with the 3 columns).
Then I have another file (dt2), Where i have put all the societies and make a references table. Which means that I have collected the right name (using in the Coala App). So from the list (of the dt1), i have to take the first society, looking into the dt2, on the “Correspondance” sheet, the name used in Coala App, either on the column “Synthèse Dossier Coala” or (if empty) “Nom du dossier Manuel”. Domiciliation_vs_Coala - Copie.xlsx (120.9 KB)
And then, to write the goo name into the DT1 (where i will add a new column, named Name_Coala, for instance)
I hope this time i was clear (sorry for my english too)