How to group primary field and select the max value row from other column - Design Model on Datawatch Data Prep Studio

Nisse

Hello Altair Team,

I have been finding a solution to get one report working, but no lucks 
And, I would like to ask for your advice on the scenario below.

Scenario:

1) I have designed the model to trap the data and result in the table below

AccountName	Total Credit	Total Debit	Total Amount
AAA 111	0	0	0
AAA 111	1	1	1
AAA 111	2	2	2
BBB 222	0	0	0
BBB 222	1	1	1
BBB 222	2	2	2

 2) I would like to have modify and apply the functions to group 'AccountName' and select the max value from column 'Total Credit','Total Debit','Total Amount'. as resulted in table below.

AccountName	Total Credit	Total Debit	Total Amount
AAA 111	2	2	2
BBB 222	2	2	2

 Is there a work around solution that we can design the table without having to export to the file or table outside of Data Prep Studio?

Thanks alot Team!

Mahmoud

Hi Nisse,

I am assuming you are using Monarch classic. 

One option would be to use Monarch DPS and trap your data as you are doing it in Classic.  You can then use Group by in DPS to group records by AccountName column.

The second option to create a summary in Monarch Classic.  Add Accountname field to the key list and other fields to the measure list.

The following screens shows both options in DPS and Classic.

Regards

Mo