nirupama
3 years agoNew Contributor II
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
Please find the attached sample pipe:
test_2022_12_01.slp (6.2 KB)
Hope it will helps!
BR,
Spiro Taleski