I don't think Generic is capable of doing that. I'd recommend storing it in KBC as JSON by using "forceType": true
(https://developers.keboola.com/extend/generic-extractor/configuration/config/mappings/#column-mapping105). And then process it in the transformation.
Question or a Poll
Q&A (Help Needed) Generic Extractor. Is there a way how to parse simple JSON object with many key/value pairs to table? (see sample JSON and expected table)
Generic Extractor. Is there a way how to parse simple JSON object with many key/value pairs to table? (see sample JSON and expected table)
Where am I?
In Keboola you can ask and answer questions and share your experience with others!