I am trying to write a quick Data Job that will convert an .xlxs file to a delimited .txt file. I am using the Document Conversion Node for my input file and Document Extraction node and then output to a text file. Attached is a sample of the output that has been converted to Excel. I cannot figure out why the unique lines continuously repeat. A file of 300,000 records explodes to several million as a result. I reviewed the SAS documentation for this process and am doing everything as it says to. Unfortunately, I cannot find help anywhere else. I would appreciate any guidance on making this perform as I expect. Thank you.
... View more