• Quiestion on formula for IF and And functions

    I am a new user of Monarch.  Is there a way create this excel formula "=IF(AND($G2>$AL$1|$AJ2="")|$AL$1-$R2|IF(AND($G2<$AL$1|$AJ2="")|$AL$1-$G2|IF($AJ2=""|$AL$1-$R2|0)))"  in Monarch?   Thank...
    Rene Tan
    last modified by Rene Tan
  • Macros not functioning within exported filename

    After the source file is processed by Data Dump and then the resulting .xlsx is created, instead of the creating as 11-19-2018.xyz.xlsx it is creating as &[mm].&[dd].&[yy].xyz.xlsx.   We are using an...
    Brandon Leib
    last modified by Brandon Leib
  • Macros not functioning within exported filename

    After the source file is processed by Data Dump and then the resulting .xlsx is created, instead of the creating as 11-19-2018.xyz.xlsx it is creating as &[mm].&[dd].&[yy].xyz.xlsx.   We are using an...
    Brandon Leib
    last modified by Brandon Leib
  • Automating a model of a workspace

    I'm still trying to advance my knowledge and experience within the monarch suite, and I cannot seem to figure out how to create a model within a workspace in DPS that will automatically apply to new reports without in...
    David Rubin
    last modified by David Rubin
  • Smart Meter Monitoring & Analysis

    Open video

    Hugh Heinsohn
    last modified by Hugh Heinsohn
  • Monitor IoT Sensors with Panopticon Control Charts

    Open video

    Hugh Heinsohn
    last modified by Hugh Heinsohn
  • Datawatch Altair Customer Letter

      Valued Datawatch Customers: Earlier this week, Altair Engineering Inc. announced an agreement to acquire Datawatch. I am personally extremely excited about this transformative combination and look forward to ...
    Rebecca Cronin
    last modified by Rebecca Cronin
  • 15.2 upgrade Loving it so far

    I just upgraded from 14 to Monarch 15.2 and so far I like the improvements I have seen. Thank you for fixing the Copy/Paste that keeps my Monarch Formatting when pasting to Excel. It will save me so much time not ha...
    hellback _
    last modified by hellback _
  • When using DataWatch API, the GetStatus() method does not give correct status

    I used the DataWatch API to call the DataWatch process from a .NET program. I could call the correct process but I could not get the correct status from after the process is called.  I think it's because the GetS...
    Chung Lee
    last modified by Chung Lee
  • Creation of Unique File Exports with Automator - shared success

    In the process of creating new automated processes, I reviewed numerous postings on this board regarding the creation of unique file names.  While there are some simple solutions, none fit my need.  I though...
    Brian Johnson
    last modified by Brian Johnson
  • Introduction to Panopticon 17.1

    Open video

    Hugh Heinsohn
    last modified by Hugh Heinsohn
  • Access Error Message on Export - Office 365

    Has anyone else had problems exporting tables to Access after upgrading to Office 365? I'm getting a "Microsoft.ace.oledb.12.0 provider is not registered on the local machine" error message. Our IT department has look...
    Amy Grube
    last modified by Amy Grube
  • Uploading documents to Sharepoint from within Automator

    I am new to both Datawatch Server (Automator) and SharePoint Online. I see it is possible in the Automator documentation but it only says to enter the Sharepoint document library URL. Has anyone out there been succes...
    Dean Rhyno
    last modified by Dean Rhyno
  • Reporting on PeopleSoft 8.8 Database

    Has anyone tried to connect to and report on an old 8.8 version of PeopleSoft? Is this possible? We have our legacy system in this format and would like to write adhoc reports when inquiries come up.
    Paul Dziedzic
    last modified by Paul Dziedzic
  • Transforming Multiple Reports Using One Workspace

    Each report that is being dropped into the workspace has four records of data which must remain grouped.   Our result looks like the following: What I would like is to be able to drop multiple reports into th...
    Chris Davey
    last modified by Chris Davey
  • Moarch's Report output is null

    Hi,   I use Monarch 15 samples to do the report export. With command,   "C:\Program Files\Datawatch Monarch 15\Monarch.exe"  /rpt:"C:\Users\Public\Documents\Datawatch Monarch\Reports\Composers.rpt" /m...
    David Dong
    last modified by David Dong
  • Monitor and analyze real-time market data & equity trading activity

    Open video

    Hugh Heinsohn
    last modified by Hugh Heinsohn
  • Monarch Server Automator - Workspaces

    I have just recently started using Monarch Data Prep Studio.  I created my 1st Workspace and am now looking to add it to my automator processes.  Currently I use automator to send out several reports daily u...
    Melissa Falardeau
    last modified by Melissa Falardeau
  • Salesforce Connectivity Issues - API?

    Hello!   I am currently having issues viewing any Salesforce data or reports via Monarch. I successfully log into Salesforce via the API, but all I see is a blank list of reports and I cannot continue to the nex...
    Nathan Och
    last modified by Nathan Och
  • Lining Up Trapped Data from Joined Templates

    Hello,   I am new to using Monarch (I have v15) and I am currently having an issues aligning two templates I am joining. The following is the layout that my report starts as before trapping: The following i...
    Chris Davey
    last modified by Chris Davey