Adjusting SQL Select statement ore split collums

Rudolf — Fri, 08 Apr 2022 14:01:24 GMT

i am working on a new Reporting using date receiving via REST.

The generated script:

RestConnectorMasterTable:
SQL SELECT
"status",
"__KEY_root",
(SELECT
"resultType",
"__KEY_data",
"__FK_data",
(SELECT
"__KEY_result",
"__FK_result",
(SELECT
"pod",
"__FK_metric"
FROM "metric" FK "__FK_metric"),
(SELECT
"__KEY_values",
"__FK_values",
(SELECT
"@Value",
"__FK_values_u0"
FROM "values" FK "__FK_values_u0" ArrayValueAlias "@Value")
FROM "values" PK "__KEY_values" FK "__FK_values")
FROM "result" PK "__KEY_result" FK "__FK_result")
FROM "data" PK "__KEY_data" FK "__FK_data")
FROM JSON (wrap on) "root" PK "__KEY_root";

The table i get shows two Rows containing the Data as shown:

What i want to do is splitting the second Collum in two ore creating a new table showing 3 collums:

__Key_values | values | timestamp

I tried with with subfield but that did not help me out.

Is there a way to adjust the sql loadscript?

Are there any further infos you need please contact me.

I am looking forward hearing from you

Best Regards

Rudolf

topic Adjusting SQL Select statement ore split collums in QlikView

Adjusting SQL Select statement ore split collums