Re: Adjusting FlattenJson output

2023-06-01 Thread James McMahon
Very interesting re your discovery. Thanks very much for sharing that Matt. I do want to keep the schema intact. I will try ScriptedTransformRecord. Thanks again for replying Matt. Cheers, Jim On Thu, Jun 1, 2023 at 10:13 AM Matt Burgess wrote: > Jim, > > I tried to use Jolt for this but I

Re: Adjusting FlattenJson output

2023-06-01 Thread Matt Burgess
Jim, I tried to use Jolt for this but I found in the doc that if you try to set an empty array or map to null or the empty string it will retain the empty array or map (no idea why). Since you know the name of the fields (and I assume want to keep the schema intact) you can use