Moving values from a column into multiple columns on one row defined by flag

lcoghlan — Wed, 08 Jun 2022 10:07:17 GMT

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.
  ]
]

Re: Moving values from a column into multiple columns on one row defined by flag

MarcoWedel — Wed, 08 Jun 2022 16:26:13 GMT

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/1933673

topic Re: Moving values from a column into multiple columns on one row defined by flag in QlikView

Moving values from a column into multiple columns on one row defined by flag

Re: Moving values from a column into multiple columns on one row defined by flag