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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
himanshup
Contributor III
Contributor III

How to send empty string through tWriteJSONField and not a NULL

Hi,

Hi I am new to Talend.

My data elements could have a NULL value. I need to be able to send an empty string ("") in place of that NULL.

Currently the JSON out of the tWriteJSONField is:

{
"LastName": "Young",
"FirstName": "Nolan",
"MiddleInitial": [],
"Title": "Tester",
"Administrator": "1",
"Username": "Noyoung"
}

 

 

I need to have "" instead of the array []

"MiddleInitial": "",

 

Thank you.

 

About our Talend Install:

Talend Studio 8

Build id: 20240524_0800-patch

Labels (2)
1 Solution

Accepted Solutions
himanshup
Contributor III
Contributor III
Author

Thank you.

In the Advanced setting for tWriteJSONField, I checked the box - Pass null values and empty strings explicitly, and that resolved the issue.

 

View solution in original post

2 Replies
Dave_Simo
Creator II
Creator II

Hello,


You can use this in a tJavarow to replace the [] with ""

Dave_Simo_0-1728051852527.png

Best Regards,

himanshup
Contributor III
Contributor III
Author

Thank you.

In the Advanced setting for tWriteJSONField, I checked the box - Pass null values and empty strings explicitly, and that resolved the issue.