Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am loading data from an api which has given me a parsed json format which looks like table1 image below when loaded into qlikview.
I want to be able to have a distinct _Key_root value and move the @Value field horizontally across multiple columns to look like table 2 and repeat for the key field to be 2,3 and so on.
It could also be possible to make a key for each value based on the example json with field name commented but I cannot figure out how to assign a value in the column based on the order the data is loaded in.
Any help is much appreciated.
Table1:
Table2:
Example Json format:
[ [ 1499040000000, // Open time "0.01634790", // Open "0.80000000", // High "0.01575800", // Low "0.01577100", // Close "148976.11427815", // Volume 1499644799999, // Close time "2434.19055334", // Quote asset volume 308, // Number of trades "1756.87402397", // Taker buy base asset volume "28.46694368", // Taker buy quote asset volume "17928899.62484339" // Ignore. ] ]
maybe this solution works for you as well:
https://community.qlik.com/t5/App-Development/split-a-key-value-table-into-multiple-columns/td-p/193...