JSON Extract : Output upstream columns in JSON array node

Question

I use JSON Extract from the SSIS library KingswaySoft to parse a JSON content.

From the root JSON, I can output the input columns (named upstreams) :

But it don't look possible from a array node :

How can output the input columns in the array node output?

Answer 1

It seems that the upstream is only available on the root output. The solution is to merge the node array output with root output.

In the node array output add the _ParentKeyField :

This column take the value from root's column specify in "Output Settings" (by default _RowIndex) :

The merge need the output to be sorted. Open the JSON Extract with "Show Advanced Editor...". In the tab "Input and Output Properties", set the property IsSorted to true for the output "Root" and " :

Set the property SortKeyPosition to 1 for :

• Root\Output Columns\_RowIndex
• <node array output>\Output Columns\_ParentKeyField

In the flow, add the a "Merge join" and redirect the root output to left join and the node array output to right join. Configure to join on "_RowIndex=_ParentKeyField" :

Finally, you can select the desired column :