Hello,
I am trying to read a file from IT to create a data table but the file is an unstructured, data file. This is the error I get when using the Read CSV activity:
“Read BAI File: The CSV file format for S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\BAI2\test.BAI2.20200326.MILTRANS.csv is invalid. Line 3 contains more values than the header line.”
After talking with It, there is no other way to get this data so I’m curious if anyone knows a way to still be able to read the file? Below is a screenshot of what the data looks like: