I want to know how to load a file with the following JSON data.
{
"ErrorCode": 0,
"ResultSets": [
{
"ColName": [
"date",
"name",
"ZQDM",
"sc",
"content"
],
"Content": [
[
"20230428",
"*ST和科",
"002816",
0,
"由和科达变为*ST和科"
],
[
"20230428",
"*ST弘高",
"002504",
0,
"由ST弘高变为*ST弘高"
],
[
"20230428",
"*ST明诚",
"600136",
1,
"由ST明诚变为*ST明诚"
],
[
"20230428",
"*ST碳元",
"603133",
1,
"由碳元科技变为*ST碳元"
],
[
"20230428",
"*ST西域",
"300859",
0,
"由西域旅游变为*ST西域"
],
[
"20230428",
"ST天顺",
"002800",
0,
"由天顺股份变为ST天顺"
],
[
"20230428",
"ST宇顺",
"002289",
0,
"由宇顺电子变为ST宇顺"
],
[
"20230428",
"ST贵人",
"603555",
1,
"由贵人鸟变为ST贵人"
],
[
"20230428",
"ST迪威迅",
"300167",
0,
"由迪威迅变为ST迪威迅"
]
]
}
]
}The effective data is the node of "/root/ResultSets/", it is composed by two parts, the first part is the list of the columns' name as the node "/root/ResultSets/ColName", the second part is the body of the data table as the node "/root/ResultSets/Content", depicted by a two-dimension JSON datum.
Now I used the following JSON Settings in open file function, but cannot set the columns'name with the data in node "/root/ResultSets/ColName".
JSON Settings(
Stack( 0 ),
Col(
"/root/ResultSets/Content",
Column Name( "Content" ),
Fill( "Use Once" ),
Type( "Pandas Values" ),
Format( {"Best"} ),
Modeling Type( "Continuous" )
)
),
I want to know how to load the JSON data into a data table with proper column name.
