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
