Exporting text file with CSV formatting, but with different numbers of fields

Hi @vaidyarm,

I’ve put together a pipeline where I simulate your case. In it I propose two solutions. Assuming that the $olditem array is anywhere in the hierarchy of the input document:

1. If you put jsonPath($,"$..olditem")[0].map(x=>{"row":x.id}) in an Expression in a Mapper, and assign it to $batch Target Path, you should get the output you described.
2. The second solution has 2 Mapper Snaps. In the first one, I extract $olditem from anywhere in the hierarchy and assign it to $batch. In the second Mapper, i designate $batch[*] as Mapping Root, and I proceed to remap the array elements.

Here’s the pipeline:
Array_key_value_pair_2020_07_01.slp (9.0 KB)

BR,
Dimitri