Log in to follow, share, and participate in this community. Not a member? Join Now!

Recent Activity

Raymond Glass
Hi everyone,   Anyone had any luck in creating a formula field that rounds a time value (say, to the nearest half hour?)  I feel like I've tried everything under the sun short of a regular…
in Datawatch Monarch
Bruce McHendry
Hi, Several people on my team are using v14 Monarch to create models for report mining. We have a list of activation codes. I want to reconcile that list against each developers PC. Is there an easy…
in Datawatch Monarch
Syed Ibrahim
Hi Team,   Could some one please help my problem, i created a process in Monarch Automator to extract data from PDF and export to Database, some of the numeric column values of PDF are exported to…
in Datawatch Monarch
Melissa Falardeau
Hello!   I have an excel sheet that has 99 tabs.  Each Tab is similar in its set up just different Data.  Is there anyway I can input all the tabs into a Monarch without having to set up each one by…
in Datawatch Monarch
Brian Johnson
I am hoping to distribute files to clients that have detail within my project, but allow the e-mail distribution list to be variable.  I have a client data file to which I'm using an external Lookup…
in Datawatch Monarch
Chris Davey
Hi Datawatchers -   I'm fairly new to Monarch and the DPS, but so far I'm really enjoying it. That said, can anyone explain (in as simple terms as possible) the difference between creating an…
in Datawatch Monarch
Chase Ramsey
Hi,   I am looking for a way to dynamically merge all columns after the first column. I have a table that will have a different number of columns based on the file selected in the file path, and I…
in Datawatch Monarch
James U
Hi,   Is there any way to create a model in Monarch Classic using source data from an Excel Work Sheet to run as a model in Data Prep Studio? I have tried this several times using a simple model,…
in Datawatch Monarch
Natalie Mahoney
Hi,   I'm trying to use an if statement as I would in Excel, but not getting anywhere. This is my formula. They are all numeric fields.     IF(([Total Amount]*[Exchange Rate])=0,[Total…
in Datawatch Monarch
Chase Ramsey
Hi everyone,   I am a new Monarch user and have a feeling this question may be incredibly obvious, so I apologize in advance if it is.   I am using Monarch to search for a list of keywords within…
in Datawatch Monarch
Load more items