Additional column after tWriteJSONField

[Jacco_De_Zwart]

Hi all,

I have a (part of a ) flow as follows :

The tMap infront of the tWriteJSONField  does some data cleaning.

In this example there are 8 rows as input, and based on the grouping column for tWriteJSONField, the end result is 4 json structures with an array in it. That is not the problem, they are generated in the correct way.

What I want is that the field that is the grouping field of the tWriteJSON component (called ConsignmentGUID), allso is in the output of the tWriteJSONfield or that I can get the column value and link is to the JSON structure that is generated. In this way, each JSON structure has it's own unique ConsigmentGUID needed for the next step.

But how do I link/associate the ConginmentGUID (the grouping column) to the output of the JSON structure ?

Thanks in advance.

Jacco

[Shicong_Hong]

@Jacco_De_Zwart 

Have you added the ConginmentGUID field in the output table of tWriteJSONfield component?  It will output the grouping column along with the JSON string. 

Regards

Shicong