The Definitive Guide to Data Quality
Solved! Go to Solution.
I added a tJavaRow after tWriteJSONField and did this:
output_row.output = input_row.output.replaceAll(",\"*\":\\", "");
Works like a charm.
BTW, for those, who faced similiar problem:
regex provided by jkrfs works for his case, but will not work if you have fields with underscore character or digits in name. Use this instead:
I have a flow going into tWriteJsonFIELD which creates an array
However, if lets say the date is missing in one of the fields, it looks like this:
Which is not what I want. If the field is empty/null I do not want it to show up in the output at all, like so:
Does anyone have any advice or ideas on how I can achieve this?
How did you achieve the below using the twriteJson, Please assist.