BI Report output shows Data_DS in csv format instead of showing empty table with columns

Question

Report output displays Data_DS when there is not resultant data

Expected:

I need the CSV output to display column names when data in not present for further integration column mapping

Please review attached document with screenshots

what can be done to get the expected output format

Thank you

Ninad

Nathan CCC · Answer

Hi, In that case you need to build your report such that it always has 1 row of data. Like join to a second dataset g_0 with a a select null from dual so you always get that row if no data found in your main data set g_1.