I need to unpacked and packed a list. Example from {"addresses": [{"city": "aaa","id": "aaa","status": "ACTIVE","type": "HOME"},{"city": "bbb","id": "bbb","status": "ACTIVE","type": "OFFICE"}]} to {"addresses": [{"city": "aaa","type": "HOME"},{"city": "bbb","type": "OFFICE"}]} . I can unpacked using the parse-as-json step. That gives me 2 rows and even if I rebuild it together with write-as-json-object I keep having 2 rows and at the end I have one file with 2 json inside.
LinkedIn
Twitter
