โ08-07-2022 12:38 AM
I am trying below data converting rows into columns
input:
[
{
โCARRIERCODEโ: โabcโ,
โSHIPCARRIERTRACKINGNUMโ: โ531โ,
โDATETIMEVALUEโ: โ2022-05-16 08:05:00โ,
โDATETIMETYPEโ: โACTUAL_DELIVERYโ,
โDATEVALUEโ: โ2022-05-16โ
},
{
โCARRIERCODEโ: โabcโ,
โSHIPCARRIERTRACKINGNUMโ: โ531โ,
โDATETIMEVALUEโ: โ2022-05-11 09:31:00โ,
โDATETIMETYPEโ: โACTUAL_PICKUPโ,
โDATEVALUEโ: โ2022-05-11โ
},
{
โCARRIERCODEโ: โabcโ,
โSHIPCARRIERTRACKINGNUMโ: โ531โ,
โDATETIMEVALUEโ: โ2022-05-11 12:00:00โ,
โDATETIMETYPEโ: โSHIPโ,
โDATEVALUEโ: โ2022-05-11โ
},
{
โCARRIERCODEโ: โabcโ,
โSHIPCARRIERTRACKINGNUMโ: โ531โ,
โDATETIMEVALUEโ: โ2022-05-11 09:49:00โ,
โDATETIMETYPEโ: โACTUAL_TENDERโ,
โDATEVALUEโ: โ2022-05-11โ
},
expected output:
any leads here
Solved! Go to Solution.
โ08-08-2022 04:11 AM
Hi @kkishore,
Group the incoming data by CARRIERCODE & SHIPCARRIERTRACKINGNUM:
And add the following expression in a mapper after the group by snap:
$group.map(x=>{[x.DATETIMETYPE+"_DATETIMEVALUE"]:x.DATETIMEVALUE,[x.DATETIMETYPE+"_DATEVALUE"]:x.DATEVALUE}).reduce((acc,curr)=>acc.extend(curr),{}).extend($groupBy)
Hope this helps,
Regards
โ08-08-2022 04:11 AM
Hi @kkishore,
Group the incoming data by CARRIERCODE & SHIPCARRIERTRACKINGNUM:
And add the following expression in a mapper after the group by snap:
$group.map(x=>{[x.DATETIMETYPE+"_DATETIMEVALUE"]:x.DATETIMEVALUE,[x.DATETIMETYPE+"_DATEVALUE"]:x.DATEVALUE}).reduce((acc,curr)=>acc.extend(curr),{}).extend($groupBy)
Hope this helps,
Regards
โ08-09-2022 05:33 AM
Thank you @bojanvelevski , perfect it is working as expected.
โ08-09-2022 08:39 AM
Thank you @kkishore, can you please mark @bojanvelevskiโs suggestion as a Solution so that anybody looking at this thread in the future can refer to the solution directly?