6 Replies Latest reply: Dec 14, 2015 11:44 PM by ashishdutt RSS

    How to aggregate a column values based on another column in Monarch 13?

    ashishdutt

      Dear all,

      I have just started to use DataWatch Monarch 13 32-bit since 2 days.

      The data is in XML files which I have managed to import to Monarch.

      The data file has several columns of which one is AccountCode and other being Amount. Account codes are repetitive and the amount associated to each transaction is varied.

      I provide a sample of the data table below

      Account CodeAmount
      1001200
      1002300
      1003100
      1001100
      1002200
      1004100
      1005800
      10012980
      10023456
      100123456
      10022908

      I have two questions;

      1. How can I aggregate all the amounts based on the AccountCode

      2. How can I connect SQL Server Management Studio 2008 to Monarch 13. What is the port number for connectivity.

      Thank you for your help

       

      Cheers

      Ashish