Hi all,
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?