Forum Discussion

nirupama's avatar
nirupama
New Contributor II
3 years ago
Solved

How to get the cartesian product kind of output?

I have an Join(merge) output as below.
[
{
“BCUNAME”: “1q”,
“REQUESTNUM”: “639431”,
“no”: “4”,
},
{
“BCUNAME”: “e4”
},
{
“BCUNAME”: “rf”
},
{
“BCUNAME”: “14r”
},
{
“BCUNAME”: “26t”
},
{
“BCUNAME”: “3PH”
}
]
But I want to keep “REQUESTNUM”: “639431”, “no”: “4” in every row like below.
[
{
“BCUNAME”: “1q”,
“REQUESTNUM”: “639431”,
“no”: “4”,
},
{
“BCUNAME”: “e4”,
“REQUESTNUM”: “639431”,
“no”: “4”,
},
{
“BCUNAME”: “rf”
“REQUESTNUM”: “639431”,
“no”: “4”,
},
{
“BCUNAME”: “14r”
“REQUESTNUM”: “639431”,
“no”: “4”,
},
{
“BCUNAME”: “26t”
“REQUESTNUM”: “639431”,
“no”: “4”,
},
{
“BCUNAME”: “3PH”
“REQUESTNUM”: “639431”,
“no”: “4”,
}
]

Please suggest