How to get the cartesian product kind of output?

[nirupama]

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

[SpiroTaleski · Accepted solution]

@nirupama

Please find the attached sample pipe:

test_2022_12_01.slp (6.2 KB)

Hope it will helps!

BR,
Spiro Taleski

[nirupama]

@Spiro_Taleski

The given solution helped me. Thanks a lot!.