I keep coming across problems with the SAP file format editor in DS. I can never get it to link properly to files. Occasionally when I put in the path and file name the data preview pops up but most of the time it never works. I’ve even tried replicating one that works, change the file name to the one I want and it doesn’t work.
Is there a reason this file source editor hardly ever works, what am I doing wrong?
This one is 2 CSV files. So I have put the directory path and the name like this:
2017-00260*.csv as there are two files called:
2017-00260_1.csv
2017-00260_2.csv
I tried doing just one file and it only shows the first column from the file, and is showing the column header as data even though I set up skip row header = NO and Write row header = Yes
When setting up the file format, pick a single file to start. The previewer doesn’t find a file when you use a wildcard. At run time, wildcards work fine, but when doing set up use a single file.
Set Location to LOCAL and put the file local to where your client is installed.
Specify the file path and name in regular text, not using variables for the setup.
If you have first row headers, set the Input/Output style to Headers and the Skip Row Header to Yes.
Should work fine if you follow those steps. Obviously, you also need to set your delimiters to the correct type for the file in questions.
Thanks for those suggestions. I did try this and my file preview is showing one field called field1 yet the file has multiple columns in it with column names.
I am using flat file type, the file is excel csv.
Have setting as local with directory path and then file name, no wildcards, which I won’t need in this case anyway, and Column Delimiter = Comma, New line for row, Text delimiter = ", Headers and YES for both skip row header and write row header.
Thanks for those suggestions. I did try this and my file preview is showing one field called field1, and the data is from col 1 in the file, yet the file has multiple columns in it with column names.
I am using flat file type, the file is excel csv.
Have setting as local with directory path and then file name, no wildcards, which I won’t need in this case anyway, and Column Delimiter = Comma, New line for row, Text delimiter = " because some of the data has commas within it, Style = Headers and YES for both skip row header and write row header.
Typically when I have that kind of problem the file is not formatted properly. Have you tried opening the file in notepad, removing everything except for the header and first row of data and using that to set up the file format?
It seemed to work when I deleted the whole thing and start again with link to one file.
While here I’d like to ask is it possible to extended the row sampling as a lot of our data has long strings but not consistently, meaning the data map gives us a column size usually much smaller than what data is there.
(BOB member since 2005-09-16)