https://community.qlik.com/t5/Talend-Studio/Mapping-JSON-with-data-mapper/m-p/2345267#M112823 <P>Here is a little more information: Basically, i would need to pivot the datafield array into "columns". Every datafield array is a row, my column name is the FIELDLABEL and the value is FIELDVALUE.</P> Sat, 20 May 2023 12:49:26 GMT jonlar 2023-05-20T12:49:26Z https://community.qlik.com/t5/Talend-Studio/Mapping-JSON-with-data-mapper/m-p/2345266#M112822 <P>Hi, I am trying to map a JSON document which returns not only the objects but the meta data as well to a "flattened" JSON file. Basically each object in the array should be a column in the end. I have tried using the data mapper but without much success. Can anyone help. Here is a sample of the JSON document</P><P>{</P><P> "DATARECORD": [</P><P> {</P><P> "DATAFIELD": [</P><P> {</P><P> "FIELDNAME": "equipmentcode",</P><P> "FIELDLABEL": "EQUIPMENTCODE",</P><P> "DATATYPE": "MIXVARCHAR",</P><P> "FIELDVALUE": "AF0000-1",</P><P> "ISKEYFIELD": true</P><P> },</P><P> {</P><P> "FIELDNAME": "organizationcode",</P><P> "FIELDLABEL": "ORGANIZATIONCODE",</P><P> "DATATYPE": "MIXVARCHAR",</P><P> "FIELDVALUE": "RTQ",</P><P> "ISKEYFIELD": false</P><P> },</P><P> {</P><P> "FIELDNAME": "description",</P><P> "FIELDLABEL": "DESCRIPTION",</P><P> "DATATYPE": "MIXVARCHAR",</P><P> "FIELDVALUE": "AFFICHE: AF0000-1 (Temporaire/Flêches)",</P><P> "ISKEYFIELD": false</P><P> }</P><P> ]</P><P> },</P><P> {</P><P> "DATAFIELD": [</P><P> {</P><P> "FIELDNAME": "equipmentcode",</P><P> "FIELDLABEL": "EQUIPMENTCODE",</P><P> "DATATYPE": "MIXVARCHAR",</P><P> "FIELDVALUE": "AF1002-1",</P><P> "ISKEYFIELD": true</P><P> },</P><P> {</P><P> "FIELDNAME": "organizationcode",</P><P> "FIELDLABEL": "ORGANIZATIONCODE",</P><P> "DATATYPE": "MIXVARCHAR",</P><P> "FIELDVALUE": "RTQ",</P><P> "ISKEYFIELD": false</P><P> },</P><P> {</P><P> "FIELDNAME": "description",</P><P> "FIELDLABEL": "DESCRIPTION",</P><P> "DATATYPE": "MIXVARCHAR",</P><P> "FIELDVALUE": "Affiche AF1002-1",</P><P> "ISKEYFIELD": false</P><P> }</P><P> ]</P><P> }</P><P> ]</P><P>}</P><P></P><P></P><P>Here is the output i would like to have:</P><P>{</P><P> "values": [</P><P> {</P><P> "EQUIPMENTCODE": "AF0000-1",</P><P> "ORGANIZATIONCODE": "RTQ",</P><P> "DESCRIPTION": "AFFICHE: AF0000-1 (Temporaire/Flêches)"</P><P> },</P><P> {</P><P> "EQUIPMENTCODE": "AF1002-1",</P><P> "ORGANIZATIONCODE": "RTQ",</P><P> "DESCRIPTION": "Affiche AF1002-1"</P><P> }</P><P> ]</P><P>}</P><P></P><P></P><P>Is this at all possible?</P><P>Thanks for any help</P><P></P><P></P><P>Jonathan</P> Fri, 15 Nov 2024 21:47:13 GMT https://community.qlik.com/t5/Talend-Studio/Mapping-JSON-with-data-mapper/m-p/2345266#M112822 jonlar 2024-11-15T21:47:13Z https://community.qlik.com/t5/Talend-Studio/Mapping-JSON-with-data-mapper/m-p/2345267#M112823 <P>Here is a little more information: Basically, i would need to pivot the datafield array into "columns". Every datafield array is a row, my column name is the FIELDLABEL and the value is FIELDVALUE.</P> Sat, 20 May 2023 12:49:26 GMT https://community.qlik.com/t5/Talend-Studio/Mapping-JSON-with-data-mapper/m-p/2345267#M112823 jonlar 2023-05-20T12:49:26Z