Join based on two tables

[Parth5]

I have two tables, table A and Table B. In table A, I am getting Unclassified so I want to get the data from Table B i.e. instead of Unclassified I should get US and when it is United States it should return United States.

[Parth5]

Yes, correct

My bad. I have attached the updated file. When there is US then US and UK for UK

[Jean-Balteryx]

I joined a workflow that I feel, only using TableA, would suit your need, retrieving all information from field "Company". Tell me if you'd rather isolate missing data in another table.

[Jean-Balteryx]

Hi @Parth5 !

Did you solve your problem ?

[Jean-Balteryx]

Hi @Parth5 ,

Is your problem solved ?