Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
replaceAll(",?\"*\":\\", "");
I have a flow going into tWriteJsonFIELD which creates an array
{docs:}
However, if lets say the date is missing in one of the fields, it looks like this:
{docs:}
]}
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:
{docs:}
Does anyone have any advice or ideas on how I can achieve this?
Thank you!
Hi,
How did you achieve the below using the twriteJson, Please assist.
{docs:}
Thanks,