topic Join Tables with Condition when a target column is blank then Join with next available in Alteryx Designer Desktop Discussions

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

Parthasarathi — Fri, 30 Sep 2022 06:41:05 GMT

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

Re: Join Tables with Condition when a target column is blank then Join with next availabl

messi007 — Fri, 30 Sep 2022 06:59:44 GMT

@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

Re: Join Tables with Condition when a target column is blank then Join with next availabl

Parthasarathi — Fri, 30 Sep 2022 07:07:15 GMT

messi007,

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

Re: Join Tables with Condition when a target column is blank then Join with next availabl

Qiu — Fri, 30 Sep 2022 07:11:08 GMT

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

Re: Join Tables with Condition when a target column is blank then Join with next availabl

messi007 — Fri, 30 Sep 2022 07:14:06 GMT

@Parthasarathi,

Attached the updated workflow.

Re: Join Tables with Condition when a target column is blank then Join with next availabl

Parthasarathi — Fri, 30 Sep 2022 08:09:10 GMT

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.

Re: Join Tables with Condition when a target column is blank then Join with next availabl

Parthasarathi — Fri, 30 Sep 2022 08:10:39 GMT

Qiu,

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

Re: Join Tables with Condition when a target column is blank then Join with next availabl

Hamder83 — Fri, 30 Sep 2022 11:49:11 GMT