Lookup on Master data and populate a column in child based on a common column name

Question

Hi All,

I have to check on my master data file to get a column value for my data workbook. Below are the master data and expected results, please help me on this with a sample workflow.

Master Data:

CompanyGroupCompany1Group1Company2Group2Company3Group3Company4Group4

Company5Group5

Child Table:

Expected output with the Parent column update from Master table's Group name based on the Company name. If the company name is not available in the master table then have to use the same company name as Group name.

CompanyParentCompany1Group1Company2Group2Company3Group3Company6Company6

Emmanuel_G · Accepted Answer

@Parthasarathi

The logic of workflow :

1 - make a join by company between the master data and another database containing the names of companies.

2 - For all the company names not found in the master data, we assign them the company name in the parent column.

Do you want something like this ?

Let me know if there is any issue and do not hesitate to mark this answer as solution if it helped. 🙂