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!
