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

@nirupama

Please find the attached sample pipe:

test_2022_12_01.slp (6.2 KB)

Hope it will helps!

BR,
Spiro Taleski

2 Likes

@Spiro_Taleski

The given solution helped me. Thanks a lot!.