I have a file that I receive (Microsoft Excel 97-2003 Worksheet) which I recevie on a regular basis.
The file always has the same number of fields, although the number of rows may vary.
Every time I receive the file I save it to the same directory. Once I have enough, I use the Dynamic Input tool to compile them into a single sheet and then distribute via various outputs/formats.
The problem I'm running into is that I will often get this message:
"The file (yourfilenamehere) has a different # of fields than the 1st file in the set and will be skipped"
I have finally been able to narrow it down to the root cause of that file just doesn't have a value for the first record past the header in the last column.
So, a file that works will look like this:
And a file that doesn't work will look like this:
I thought that maybe since it was detecting a header with no record that delclaring the first row as data would resolve this; but surprisingly it didn't.
Even if I set the dynamic input to treat the first row as data, it would still skip the file if there was an empty set in that last field.
The field comes from a government feed, so the chance of it being changed at the source is almost impossible.
Aside from opening up, checking the file, and inserting adummy value every time.... any ideas on how to automate a fix?
