Join Producing Null

[CBoardy98]

Hi All,

I am creating a workflow but when I Join two different data sources a completely unrelated Field is creating Null outputs.

In the pictures attached below you can see that the column "Type" contains text like BI, SNI, NPNS etc... I have checked this multiple times but when filtering for Null Values in that column the result is blank, there aren't any lines which are Null. Now looking at the Right & Join outputs I can clearly see that there are Null Values being churned out mixed in with the text I'd be expecting to see.

I have triple checked that all the data sources format "Type" as V_String & so is output. Is anyone able to provide insight to the issue and what potentially it might be?

Many Thanks.

[CBoardy98 · Accepted solution]

Ignore this. Stupid mistake on my half. Overlooked data source which didn't contain the column