Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Handling nulls for integer columns while creating JSON for tMongoDBOutput

Hi, 

I am generating the JSON structure to insert to my MongoDB using tMongoDBOutput stage. In the Configure JSON Tree, I have specified attribute "type" as integer for the Integer fields.But the job is failing when NULL values are incoming from the source. My source is a SQL server DB.0683p000009Lss9.jpg

 

0683p000009Ltk1.jpg

Can anyone assist on this please.

Thanks,

sr

Labels (3)
10 Replies
Anonymous
Not applicable
Author

where do i need to set this value?