community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Confirming All Records in Union

Asteroid

Hello Alteryx Community! 

 

I am combining ~25 files of the same format into a Unioned file. The Union seemed to be adding about 50 extra records for some reason (out of about 625,000 records). Is there some way I can make sure all records from the 25 files are being included in the Union? Either, 

  • Automatic sum check with the number of records in each file equaling the number of records in the unioned file (rather than having to add manually)
  • Or, tracking each record to see where the addition occurred

 

Any insight would be appreciated. 

 

 

Thanks!

Highlighted
Alteryx Partner

Hello @Nageen ,

 

that is strange. Are you sure there are no extra lines in your excel files? I would recommend you to first do a null check value with a filter tool on a column that should always be filled just to check if some extra lines from the excel files were taken.

 

Sometimes, even if you have empty rows, alteryx will take the lines filled with nulls (happens mostly on bottom lines from the files).

 

If thats not the case tell me and I will think about another solution (have one already in mind but is kinda overcomplicated :P)

 

cheers

Asteroid

That helped me figure out which file was pulling in nulls. Thank you!

Labels