Join Tool not having the correct output. How to add empty fields?

Hello guys, how are you doing today?

I am trying to join two datasets together.

First dataset is a dummy text input (which contains the name of 5 testers people).

Second dataset is exported directly thought SQL and contains the name of the testers of the day. Normally only three or two contribute on each date.

The problem is that when joining it is not showing the five testers (some with NULL values). Its only showing the testers of the day which is wrong, example:

When combining then, they are joined like this:

The correct WOULD be like this:

How to solve this? Thanks 🙂

Add Empty Fields.yxmd

Workflow

Accepted answers

All comments

apathetichell

you are using the union tool which add records as opposed to the join tool which allows for an inner join or a join and then a union which allows for a left/right/inner/outer join.

see attached.

Add Empty Fields.yxmd

Joker_Hazard

Hey Apathetic

There is a problem, the input from SQL does not have a constant column. It varies, it could be like this:

Or like this:

Then the union tool does not work..

apathetichell

check out the workflow I posted and let me know if that's closer and how it deals with your dynamic data.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703