Hi All, I am trying to Join a table instead of VLookUp, but Join resulting in duplicates including blank/null values in the Target columns. But I want to skip the null/blank then to have only the output rows with values on the Target columns. Thanks in advance. Table 1: Master TableCompanyParentCompany1Parent1Company2Parent2Company3 Company3Parent3Company4 Company5 Company5 Company5Parent5 Table 2: Input dataCompany nameGroupCompany1G1Company2G2Company3G3Company4G4Company5G5 Expected Join Component Output:Company nameGroup/ParentCompany1Parent1Company2Parent2Company3Parent3Company4Company4Company5Parent5

messi007, Thank you for your workflow. But when I have two Parent name it is giving duplicate, actually if more than one Parent then I need to pick the first available value.

Join Tables with Condition when a target column is blank then Join with next available

Parthasarathi

Hi All,

I am trying to Join a table instead of VLookUp, but Join resulting in duplicates including blank/null values in the Target columns.

But I want to skip the null/blank then to have only the output rows with values on the Target columns. Thanks in advance.

Table 1: Master Table
Company	Parent
Company1	Parent1
Company2	Parent2
Company3
Company3	Parent3
Company4
Company5
Company5
Company5	Parent5

Table 2: Input data
Company name	Group
Company1	G1
Company2	G2
Company3	G3
Company4	G4
Company5	G5

Expected Join Component Output:
Company name	Group/Parent
Company1	Parent1
Company2	Parent2
Company3	Parent3
Company4	Company4
Company5	Parent5

Designer Cloud

Accepted answers

All comments

messi007

@Parthasarathi,

Please see below :

I don't understand one thing, you need to skip null/blank and in the expect result I see company 4 however it's blank in the input master table.

Attached the workflow,

Regards

Join_20220930.yxmd

Parthasarathi

messi007,

The column4 is available only once that too blank, so using the Company name as the Group without any master table reference.

Qiu

@Parthasarathi
What is the use for your input table 2?

Parthasarathi

Qiu,

For the Table-2 only I need to get the matching values from the Master table.

Hamder83

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703