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

[dberroth]

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?

[dberroth]

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

column1 column2 column3 column4 column5 column6

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

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

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

null         null         null          data       data        data

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.

Example of a Join:

Example of a Union:

[dberroth]

thanks but I'm really just trying to merge these two together, nothing else. so for example

Data source 1                                            Data Source 2

column 1 column2 column3                      column 1 column2 column3

house     2             4                                  house     2             4

house     4             5                                  house     4             6

star         3             7                                  star         3             4

Desired Output ( NO manipulation, just merging all 6 total columns into same file )

column 1 column2 column3 column4 column5 column6

house     2             4             house     2             4

house     4             5             house     4             6

star         3             7             star         3             4

[dberroth]

Your union solution makes sense and was the road I was down, but it was creating a lot of nulls between the two data sources

[prozanini]

For this "horizontal" union, you can use a Record Id tool followed by a join using the RecordId column as key.

[rupali_bhise · Accepted solution]

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