Transponse Fields from tExtractJSONFields

Anonymous · ‎2019-02-27

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

Anonymous · ‎2019-03-06

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