I have a CSV-file that I need to import into DI Studio. I've set up a transformation with this user written code:
proc import
file='foldername/filname.csv'
out=&_OUTPUT. replace;
getnames=yes;
quit;
As you can see, getnames is set to "yes". I should also mention that the first row of the CSV-file contains column headers.
The job runs without any warnings or errors, but when I attempt to open the output table, it tells me "Error accessing metadata: Table has no columns".
How can I remedy this?
Thanks for your time.