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
Shop | | SHOPPING
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.
@ppr maybe you will be able to help me.
Thank you in advance