This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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)