Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
angietlj
Partner - Contributor
Partner - Contributor

Loading Postgres JSONB to QVD

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

CurrencyRate
USD253
SGD123
EUR122

 

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? 

 

Labels (5)
0 Replies