In QlikSense Enterprise, I have a requirement to load Postgres JSONB fields and transform it to a table in QVD.
Example of JSON:
{
"USD",253,
"SGD",123,
"EUR",122
}
Will like to transfer the above JSONB field to the following table in QVD
Currency
Rate
USD
253
SGD
123
EUR
122
Just wonder will transforming JSONB field to a table in QVD take long and does it required the data to be sorted in a certain matter for it to be transform to the right format?
