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.
as a variant - use search function :-)
(it more than 1 of course)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema