Categories
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
