You can translate the question and the replies:

remove column when null

Hello, I have exposed the data in JSON and now I want column/key which has null value in it should not appear in JSON, example: ``` { "student": "1203", "Rollnumber": "1", "status": "deactivated", "Grade": "7", "major subject": "PHE", "name": "June", } { "student": "12312", "Rollnumber": null, "status": "deactivated", "Grade": "5", "major subject": "IP", "name": "August", } ``` what is expected, as rollnumber in second null I dont want to display it: ``` { "student": "1203", "Rollnumber": "1", "status": "deactivated", "Grade": "7", "major subject": "PHE", "name": "June", } { "student": "12312", ---here roll number key/value should not appear--- "status": "deactivated", "Grade": "5", "major subject": "IP", "name": "August", } ``` Is there any way to do it?
null
user
05-07-2021 02:56:11 -0400
code

1 Answer

Hi, if your query contains all the keys(columns) as an output format, VDP will return all the columns specified regardless of if there is a value in it or not. You can also refer to the link below for a similar case. [remove parameters from query output](https://community.denodo.com/answers/question/details?questionId=9060g00000009uBAAQ&title=remove+parameters+from+query+output) Hope this helps!
Denodo Team
09-07-2021 04:16:02 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here