Categories
Empty column missing from csv output
Summary
Empty column missing from csv output
Content
I have a BI Publisher report that extracts several columns that may or may not be populated. When they are not populated (only null values), the output does not include them when exporting the csv.
Is there any way to force every column that is specified in the data model to be present in the csv output?
There is a setting for dynamic columns in the report properties under 'FO Processing', however that doesn't seem to be what I'm looking for.
Any help will be appreciated.
Many thanks,
Antony.
Answers
-
You are welcome.
0 -
Hi Antony,
Did you try the below option
0 -
Took me a while to find it, but I knew I'd seen it somewhere, in case anyone else is unsure of where to find this setting:
Yes that's exactly the one, and it also showed me how to remove parameter tags.
Thank you so much, really appreciate it.
Antony.
0 -
Hi Antony, Can you please re-upload the image which has the solution to this problem? It shows up as a broken link.
0 -
Hi,
Please can you re-upload the image. I have got exactly the same issue.
0 -
Hi @Antony Hooper-29731, could you please re-share the image? I am dealing with the same issue and would like to understand the solution.
0 -
Hi @Sherry George, could you please re-share the solution that was provided? I don't see the solution/image in this thread. I am dealing with the same issue and would like to understand the solution.
0 -
Both users aren't active in this forum. This question was imported from another platform.
Please post a new question in , post your product name and version and your question with all the details for other people to be able to provide replies.
0
