Skip to Content
0
Oct 28, 2018 at 01:57 PM

Group and Sum in Message Mapping

427 Views Last edit Oct 29, 2018 at 08:29 AM 2 rev

Hello Experts,

I need your inputs on same please help me on below requirement on mapping :

Requirement :

1) Need to Concatenate 4 fields:

Field name : Value

a)field 1 : 23456

b) Field 2 : 5630

c) Field 3 : 20

d) Field 4 : 20.08.2018 ( Date)

This will become key

2) Key will be used for grouping same values

3)Now sum all the values of column name xyz ( decimal upto 2 digit) based on

same key value

e.g suppose concatenate results is 2345656302020.08.2018 This is become key

Now group key 2345656302020.08.2018 based on same key and sum all the values in column XYZ

Xyz key

1.100 2345656302020.08.2018

10.200 2345656302020.08.2018

30.300 2345656302020.08.2018

We need to send the sum of 3 fields XYZ =41.60 ( upto 2 digits) as output value for same key 2345656302020.08.2018 to target Field abc only once.

How i can achieve this requirement through graphical mapping?Please advise.

Thanks

Geetanshi