tfilejson readby option & space in json field

[rk2019]

Hi Team,

I have below json to convert into psv and then need to load into Redshift but confused with the Read By

1.XPATH 2.JSON PATH 3.JSON PATH WITHOUT LOOP

for below 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

           },

   ]

]

Also how I can used tfileinput json for field with space. example

Manufacturer Name

[Anonymous]

Hi

The column name can't contain blank space, you can rename it to Manufacturer_Name, I am not sure if I understand your issue well.

Regards

Shong