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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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("\\:\\{","\\:\\[\\{")