dynamic json field with nested arrays

[rk2019]

Hi Team,

I have a source file in json where I am getting dynamic array having extra field and some with nested array and some doesn't have nested array , can you please suggest how I can approach this scenario .

Need is to convert into psv file and then load into redshift Table. Appreciate your help, Thanks!.

Here is the sample json

 [ {   "Manufacturer Name": "ABC Corp",

       "SML ID": "S935309333",

       "EBP ID": "195558332",

       "AID": "A5",

       "Registration Status": "NotInvited",

       "Qualification Status": "Qualified",

       "Integrated to ERP": "Integrated",

  "name2" : "ABC",

  "name3" : "XYZ"

 },

 {  "Manufacturer Name": "GHY Corp",

       "SML ID": "J878333",

       "EBP ID": "998433332",

       "AID": "A7",

       "Registration Status": "Invited",

       "Qualification Status": "Qualified",

       "Integrated to ERP": "Integrated",

     "Department": [

           {

               "Qualification Status": "Qualified",

               "Preferred Status": "",

               "Category": "7838383",

               "Region": "APAC",

               "Unit": null,

               "Item ID": null,

               "Process Type": null

           },

           {

               "Qualification Status": "Qualified",

               "Preferred Status": "",

               "Category": "7838383",

               "Region": "APAC",

               "Unit": null,

               "Item ID": null,

               "Process Type": null

           },

   ]

]

[vikramk]

Talend doesn't support Dynamic schema for json files, here you can Talend data mapper if you are using Enterprise edition or else you can use with multiple input json files. For example for this requirement, only for Department you can use separate input file define the root for this, for remaining fields you can use one input json file.