I am trying to import files in via the Directory List node and CSV/Delimited Input node. However, I am getting the following error when running the Input node:
"Unexpected exception while calculating output metadata: Field "Invoice Number" already exists in metadata"
On investigation I can see that the files have TWO columns, both called "Invoice Number". Is this the problem? How can I import the data now? I don't mind dropping the second instance of that column as it has no values.
I am a new user, so any help would be appreciated.
Please sign in to leave a comment.