Transponse Fields from tExtractJSONFields

Anonymous — Wed, 27 Feb 2019 12:13:59 GMT

Hi,

i have following json-Example and i need to transponse the colums to rows.

Example:

{"Employee":

{"Mike":21,"Frank":22,"Mary":44,"RON":25}}

At the moment the output with tExtractJsonFields looks like this:

Mike | Frank | Mary | Ron

21 | 22 | 44 | 25

What i need is to transponse the data, because in this example the name is an external-id, that i need to update a table in my database:

Mike | 21

Frank| 22

Mary| 44

Ron | 25

How can i solve this problem?

Regards

Panda

Re: Transponse Fields from tExtractJSONFields

Anonymous — Thu, 07 Mar 2019 02:56:25 GMT

Hello,

Please have a look at this related topic on community.

Let us know if this solution tJavaFlex is OK with you.

Best regards

Sabrina