Hi
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