Forum Discussion

kkishore's avatar
kkishore
New Contributor III
4 years ago
Solved

Converting rows into column

I am trying below data converting rows into columns input: [ { “CARRIERCODE”: “abc”, “SHIPCARRIERTRACKINGNUM”: “531”, “DATETIMEVALUE”: “2022-05-16 08:05:00”, “DATETIMETYPE”: “ACTUAL_DEL...
  • bojanvelevski's avatar
    bojanvelevski
    4 years ago

    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

bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

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

kkishore's avatar
kkishore
New Contributor III
4 years ago

Thank you @bojanvelevski , perfect it is working as expected.