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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharathkumar1
Contributor
Contributor

Replace values form twritejson output---Help

Hi All,

 

Can you please help me with the below string replacements scenarios. I am getting the below scenarios from twritejson output. 

 

1) Replace fields":{     with  fields":[{

2) Replace suffix":" "},     with  suffix":" "}],

 

Please provide input need some urgent help.

 

Thanks,

 

 

Labels (4)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@rchinta , after tWritteJson use tjavaRow and the output column datatype need to convert from object to string from  tWritteJson and use the .replaceAll("\\:\\{","\\:\\[\\{")

 

 

View solution in original post

1 Reply
manodwhb
Champion II
Champion II

@rchinta , after tWritteJson use tjavaRow and the output column datatype need to convert from object to string from  tWritteJson and use the .replaceAll("\\:\\{","\\:\\[\\{")