combining 2 rows into one

Comments

2 comments

  • Avatar
    Gerry Mullin

    You can use groupString() in an Agg Ex to achieve that. Here's some sample code.

     

    node:Static_Data
    bretype:core::Static Data
    editor:sortkey=5d2cbbff7c960c20
    output:@40fe6c55598828e5/=
    prop:StaticData=<<EOX
    col1,col2,col3,col4,col5
    NULL,NULL,NULL,NULL,Hello
    AAA,BBB,CCC,DDD,NULL
    EOX
    editor:XY=320,280
    end:Static_Data

    node:Consolidate_using_groupString
    bretype:core::Agg Ex
    editor:Label=Consolidate using groupString()
    editor:sortkey=5d2cbc94672d0e24
    input:@4b4668c040aa5a85/=Static_Data.40fe6c55598828e5
    output:@4b4668e708143fb4/=
    prop:GroupBy=<<EOX
    1
    EOX
    prop:Script=<<EOX
    col1 = groupString('col1')
    col2 = groupString('col2')
    col3 = groupString('col3')
    col4 = groupString('col4')
    col5 = groupString('col5')

    emit col1, col2, col3, col4, col5
    where lastInGroup

    EOX
    editor:XY=430,280
    node:Bypass
    bretype:::Bypass
    editor:shadow=4b467f7e02db3a85
    input:@4b467f7e129d45c1/=
    input:@4b467f830ffe047b/=
    output:@40fd2c7436717256/=
    end:Bypass

    node:Sort
    bretype:::Sort
    editor:shadow=4b467f8972dc33df
    input:@40fd2c743ebf4304/=
    output:@40fd2c746a2a3b47/=
    end:Sort

    node:Agg
    bretype:::Agg
    editor:shadow=4b467f9b3d5028c0
    input:@40fd2c7427456e5b/=
    output:@40fd2c744c862db0/=
    end:Agg

    end:Consolidate_using_groupString

     

    1
    Comment actions Permalink
  • Avatar
    Geoff

    Yes perfect! Thank you!

     

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk