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.
