Union tool creating blank rows when merging datasets

Question

Hello all, I'm using the union tool to bring together many tools, for some reason tho when I do this, it's creating many blank rows, I need the bottom 5 rows to be moved up and be in the same rows as the top 5 rows/ 3 columns.

As background, I'm using the summarize tool which is generating the bottom 5 rows (which I want moved up). Any ideas?

Emil_Kos · Accepted Answer

Hi @dberroth,

Try using join by record position instead.

Let me know if it worked for you.

wdavis · Accepted Answer

Hi @dberroth

When you are using the Summarize to create the bottom 5 rows, does it contain a unique ID which could be used to join the data to the top 5 rows/3 columns.

It may be the case that using either a Join or Append, may be more applicable to combine your 2 data streams together.

Kind Regards,

Will

Aaron_Harter · Accepted Answer

Hi @dberroth,

Try using the 'Manually Configure Fields' option in the Union tool to align your fields:

Goppi · Accepted Answer

assuming that the values in Totals correspond to the values in Group Risk Report, you should rather use a join on thise two fields. This will give you then exactly what you asked for.