In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Different number of records in input and output files (.txt)

knozawa
11 - Bolide

Hello,

 

There are 589,981 records in output.txt.  Here is the output configuration:
Output configuration.png

 

When I try to open the output file using the input tool, the record number was different (590,584).   This is the input configuration:

Input configuration.pngCould you please help me why the output and input record numbers are different?

 

Sincerely,

knozawa

1 REPLY 1
knozawa
11 - Bolide

I tested several scenarios.  It seems like saving the .txt and .csv file with Quote = "Never" messed up the record numbers.

 

Output Summary.png

 

knozawa

Labels
Top Solution Authors