Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 18 Oracle Analytics and AI 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
