Joining 3 data streams using 'Union' results in rows with [Null] values

[sureslala]

Hello

I have 2 data streams I am combining using the 'Union' tool to derive 'day on day' movements.

In the attached example workflow, staring with 'Join'

'Join L' is my 'Day1' data consisting of Products (metals), 'Spread Used', 'Tenor' 'Positions and 'Provisions'

'Join R' is my 'Day -1' data with the same columns as 'Day1' but 'tenor', 'spread', 'positions' and 'provisions' are different values.

Join output 'L' and 'R' are modified before all 3 streams (L,J, R) are combined in my 'Union'. The incoming 3 union streams look good (although one row is [Null]?)  

The issue is with my output where the products with the (D-1) data shows as [Null]. I've somehow created another 'Product' column also on the far right of my preview screen. 

How do I remove all the [Null's] in the first column 'Product' (and not have the last 'Product' column appearing) so I can then summaries my data. 

The below highlighted text is what I want to be showing in the first column.

You can see in the 'output' (Visualize DoD change) from my attached workflow that I have created 2 'Product' columns showing [Null] values I want to remove.

Thanks for your assistance!

Sures

[AbhilashR]

Hi @sureslala, your Day1 data has a null row in its source which introduces a null row downstream. You can simply select the row and delete in the Input Text tool to remove it.

As for the issue with the new Product column introduced in the Join tool, it is because your Day-1 Input tool probably had a blank space in the column header name (i.e. Product column had a blank space). I renamed the header and joined and everything seems to flow appropriately. Take a look at the modified version of your workflow.

Hope this helps.

[sureslala · Accepted solution]

Hi Abhilash
Thank you for steering me in the right direction! you were right I had a space bar 'gap' in the header column in the file I created for (d-1) data. The column 'Product' had a space at the end of it which caused all my headaches!  Lesson learned that you have to be very careful with your inputted data! 

Thanks so much again, I did spend hours on this on the weekend trying to figure it out, I would never have looked at the possibility of a character gap in my input file.

Thanks

Sures