Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to transfer report files in csv format via ESS job to SFTP SERVER.
We need to transfer a report output as a single file to the SFTP server using an ESS JOB, so we're using a bursting query to specify the server name, path, and location. The bursting query requires a key column, so we've added a dummy column, resulting in a single output file. However, we need the output in CSV format, and in CSV, all columns from the data model, including the dummy column, are included. How can I send the report output as a single CSV file to the SFTP server without including the dummy column?
Answers
-
Hi @User_QI9MI,
Welcome to the Oracle Analytics Community!
You can use eText template and deliver the file as a text file and the data can be stored as comma delimited inside that text file. You can only choose those columns that you need if you are using eText.
Please take a look into the following document for more details.
Hope this help.
Thank you.
0
