Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
First load works (exact filename). No errors. Second doesn't and it creates an error (Field not found, Field X not found) when I use the '*' character.
Essentially everything is the same except I use the '*' in the Second and it's unclear to me what's causing the error. I'm having difficulty debugging this scenario. Any insight on best practices when it comes to debugging would be much appreciated. I noticed several items posted on this topic but none of the items helped (or I didn't find it).
First:
Load
Field 1
Field 2
FROM [FILE Location\Filename1234.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Where Field_X...
Second:
Load
Field 1
Field 2
FROM [FILE Location\Filename*.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
Where Field_X...
Thanks,
Michael
Inspected my files again and found a file that was empty. This caused the error. Thanks for the feedback.
Do you have Field 1 and Field 2 in all the files sitting at the location?
Yes. The fields are identical for all files. This has been confirmed. Thanks for the question.
Inspected my files again and found a file that was empty. This caused the error. Thanks for the feedback.
Just like I would have thought