7 Replies Latest reply: Mar 30, 2016 12:08 PM by Craig Kortlandt RSS

    Combine data different data on multiple rows

    Craig Kortlandt

      CSV table comes in and looks great.

      Problem:

      Each customer has 2 rows one for the principal payment and one for the interest payment.

      Rows are identical save for the Transaction amount column and the transaction type code (Principal or Interest)

       

      Example

      I made a $100 mortgage payment

       

      Name       Acct     Total     Transaction Amount     Transaction Type         Date    

      Joe          1234      100         25                              Principal                3/1/2016

      Joe          1234      100         75                              Interest                  3/1/2016

       

      What I'd like:

      Name     Acct     Total     Principal Amt     Interest Amt     Date

      Joe          1234     100          25                    75                3/1/2016