Categories
- All Categories
- 166 Oracle Analytics News
- 33 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Empty column missing from csv output
Hi All,
When the CSV file format report is generated , the output does not show the columns having null values
eg:
Below columns to be displayed in .csv report
col1 -10
col2-20
col3- 30
col4- null
col5- null
csv output file generated only with the columns having the below values.
col1, col2,col3
10,20,30
NOTE : Col4, col5 are not appearing.
Answers
-
Got the information on this
Fusion BI Publisher Report Columns Missing When Exporting To CSV (Doc ID 2177002.1)
1 -
Very useful information.
Thank you very much for sharing.
0 -
In the Data Model Properties, ensure :
Include Empty Tags for Null Elements : Enable to ensure if a column is fully NULL in report, it still shows up in CSV and XML
Include Parameter Tags : Disable to ensure DM parameters are not added as column in CSV and XML
2
