Hello All,
I am trying to find out an alternative of Vlookup kind of scenario in Domo. I have 2 tables -
- Employee Headcount
- Country Mapping
Employee Headcount Table contains all employee related demographys such as ID, DOJ, DOB, Country, etc. But it does not have Region and Sub-Region data in it.
For that purpose I have a Country Mapping Table and I want to bring Region & Sub Region information from Country Mapping Table to Employee Headcount Table.
I tried Magic ETL (Join & Append) and BLEND but it adds extra rows in the Employee Headcount Table. Tried Inner and Left Outer but same result. From 6.6 M rows it goes to 132 M rows.
Didn't try SQL as I don't know that. CASE fucntion of Beast Mode won't work as my list is dynamic.
Any Help please!!!