Merging two data outputs with union tool, how to remove the nulls and move date up?

The 3 left columns is data source 1, the 3 blacked out columns on the right are data source 2.,but since it is merged together with the union tool, all the columns on the left data is pushed down with nulls inserted. is there a way to remove these nulls and "push the data up" so it's cleaner to review without all these unnecessary nulls created?

Developer

Developer Tools

Input

Help

Preparation

Accepted answers

rupali_bhise

Hey @dberroth ,

You can use Join (by record position) for desired output of 6 columns. Attaching screenshot for your reference, hopefully it will work.

Good luck

Solution.png

All comments

dberroth

Sorry, apparently my upload is getting blocked. below is an example...

column1 column2 column3 column4 column5 column6

null null null data data data

dberroth

Sorry apparently my upload is getting blocked...below is an example.

column1 column2 column3 column4 column5 column6

null null null data data data

Aaron_Harter

Hi @dberroth,

If you provide some samples of your data tables, the community can provide more direct assistance. Given the null values you are experiencing, you may want to Join your data tables instead of a Union to append these new fields to the right of your original table.