Extract ColumnName and Value from JSON

Gourav_King_of_DataLand — Fri, 09 Nov 2018 11:11:30 GMT

Hello,

I have a requirement which I am not able to figure the solution for it myself.

Requirement : There is a product table which has following columns

Prod_ID - contains product ID

Prod_Name - Contains product name

Prod_config - Contains additional information about the product features in JSON format (as a sting)

Each product can have one or many features, the information of which is present in Prod_Config in key:value pair in JSON structure. I want to transform this JSON text into table format

so the the value of Prod_config

should be transformed and put in separate table like this

I linked my database input to tExtractJSONFields

From here I can manually configure individual attributes and write appropriate JSON query to extract information from them. But the problem is, the table data is from external source which I have no control on + are you might have noticed in the example one product can have 1 attribute another can have 50 and another can have 100+. I need a dynamic know all the attributes present and transform them into the require table format without manually configuring (something that I have no control of and can change very frequently). There can be new attributes added to products so I should not have to come back and update my JOB each time that happens. Hope I have explained my problem and restriction for solution.

Any help would be highly appreciated. Thank You in Advance.

Re: Extract ColumnName and Value from JSON

vapukov — Sat, 17 Nov 2018 13:55:10 GMT

Hi

as a variant - use search function 🙂

https://community.talend.com/t5/Design-and-Development/Unable-to-parse-JSON-quot-name-quot-using-tExtractJSON/m-p/134085#M83544
(it more than 1 of course)

topic Extract ColumnName and Value from JSON in Talend Studio

Extract ColumnName and Value from JSON

Re: Extract ColumnName and Value from JSON