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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Manipulate JSON input file to add additional string characters

I've got an input JSON file formatted as below:
{"column1":"abc","column2":"def"}
{"column1":"cba","column2":"fed"}
{"column1":"123","column2":"456"}

I need to modify it as below:


1.add '' as last string of the last row only
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi
Use tFileInputRaw to the whole file as a string, and then manipulate the string on a tJavaRow like this:
tFileInputRaw--main--tJavaRow--main--tFileOutputRaw
on tJavaRow:
output_row.content ="";
tFileOutputRaw, generated a new json file based on the updated file content. 
Regards
Shong