tfilejson readby option & space in json field

rk2019 — Sat, 16 Nov 2024 01:50:25 GMT

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

Re: tfilejson readby option & space in json field

Anonymous — Wed, 22 Jul 2020 03:34:29 GMT

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

topic Re: tfilejson readby option & space in json field in Talend Studio

tfilejson readby option & space in json field

Re: tfilejson readby option & space in json field