Loading exactly one column from vertical column into a row (No headers)

[lcoghlan]

Hello,

I am using the binance API to pull data of some of the most recent candlestick figures to calculate rsi. 

Unfortunately my problem occurs with the load in particular giving me the data shown in the table 1 image, which I cannot give a heading to due to it being stuck in a column but I would like the _Key_root field to remain within a column.

I assume it is possible with crosstable but I cannot figure out how to create a row based on the value being 1 then 2 and so on.

FYI - the key reflects the time period which is also one of the values within the "@Value" field.

Load Script for reference:

RestConnectorMasterTable:
SQL SELECT
"__KEY_root",
(SELECT
"@Value",
"__FK_root"
FROM "root" FK "__FK_root" ArrayValueAlias "@Value")
FROM JSON (wrap on) "root" PK "__KEY_root";

[root]:
LOAD [@Value],
[__FK_root] AS [__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_root]);

[root_u0]:
LOAD [__KEY_root]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__KEY_root]);

----------------------------------------------------------

Table 1:

I am a bit out of practice and may have missed something small but I would appreciate any help you can offer!

Thanks, 

Lee