I am new to JSON files.
I have task to create a JSON file from pipe (|) delimited file.Below is the sample data and expected output.
My Job Design is as below:
SeqFileStage--> Hierarchical Data Stage
Sample Input:
column1|column2|column3|column4|column5|column6|column7|column8
1000|ABCDEF|HIPID|30000000000002|NONPB|false|false|false
1000|ABCDEF|HIPID|30000000000003|NONPB|false|false|false
1000|ABCDEF|HIPID|30000000000004|NONPB|false|false|false
1000|ABCDEF|HIPID|31000000000002|NONPB|false|false|false
Expected Output:
Code: Select all
{
"column1": "1000",
"column2": "ABCDEF",
"plans": [
{
"column3": "HIPID",
"column4": "30000000000002",
"column5": "NONPB",
"column6": false,
"column7": false,
"column8": false
},
{
"column3": "HIPID",
"column4": "30000000000003",
"column5": "NONPB",
"column6": false,
"column7": false,
"column8": false
},
{
"column3": "HIPID",
"column4": "30000000000004",
"column5": "NONPB",
"column6": false,
"column7": false,
"column8": false
},
{
"column3": "HIPID",
"column4": "31000000000002",
"column5": "NONPB",
"column6": false,
"column7": false,
"column8": false
}
]
}
Does Hierarchical Data Stage is created/programmed in such a way where it can handle array of multiple looping records.
Thanks,
Brahma