Datawatch Forums

Monarch Novice - Need Help

dberickson — Thu, 17 May 2012 16:54:27 GMT

I only have basic Monarch training for Monarch Pro V11. I don't even really know most of the terminology so I will do my best. I am using a database and I need to fill all the empty cells in one of my fields with the current date. This will obviously change every week, so is there a way to make the model input the current date each time?
Thanks to anyone who can help! :D

External Lookup problem - 1:1 Relation

Oli — Wed, 16 May 2012 18:30:52 GMT

I've got 2 files which I like to combine.
The colums of the fields are separated in the example below with "|"

1. File:
Art-Nr | Date

2.File:
Art-Nr | Date Beginn (Period)| Date End (Period) | value

In both files are duplicates of the "Art-Nr".
In the 2. File are for duplicates of the Art-Nr different periods (Date Beginn (period) | Date End (Period) with different values

Now I like to have as a lookup the corresponding "value".

How can I give Monarch the information which Relation is the correct value ?

Art-Nr <-> Art-Nr
Date <-> within Date Begin (period) <->Date End (Period)

DateIsInRange

Oli — Wed, 16 May 2012 13:42:56 GMT

Hi,
I've got a problem with DateIsInRange.

I've got a model with:
starting period in field 1 (e.g. 01.03.2012)
ending period in field 2 (e.g. 31.05.2012)
an date field 3 (e.g. 15.04.2012)

I like to idetify all the lines which are true with the field date in field 3 (all lines which are in the periode 01.03-31.05.2012)

floating trap problem

Mriley7212 — Mon, 14 May 2012 14:56:18 GMT

Hello, This time my problem is with data in a liune that has varying number of characters. See the example below:
AC,32577,NEGREENSCA,NEW ENGLAND GREENSCAPES, INC.,,,2010-09-09T00:00:00,3533,0
,2012-09-10T00:00:00,VR 00003628-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,408
,2012-09-10T00:00:00,VR 00003629-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125
,2012-09-10T00:00:00,VR 00003630-001,,AA.3620.415,PROPERTY MAINTENANCE: TO BE CHARGED TO TAXE,S,0,125
,2012-09-10T00:00:00,VR 00003605-001,,AA.7110.430,PK. - LANDSCAPING,,0,1000
,2012-09-10T00:00:00,VR 00003611-001,,AA.7110.430,PK. - LANDSCAPING,,0,1875
The area I need starts with PROPERTY MAINTENANCE: - I have tried the floating trap using the comma as my start but there are many commas and I have tried converting the data to PRN, PDF, TXT, and Excel.

Issue 2 -When I bring it in with Excel I cant get to set up any templates to move the data around. I appreciate any help here.

Thanks,

Mike

Monarch 7 Reference Guide

Tracy Johnson — Mon, 14 May 2012 02:49:21 GMT

My company modified a years old report to change column width and of course now the model no longer works. We're on Monarch v.7. I was hoping there was something in the software that would allow me to modify the columns affected without reinventing the model.

The last forum message that referenced the v7 Reference Guilde that I could find has a link to the Datawatch web site that is no longer operational.

Did anyone manage to keep a copy of the v.7 Reference Manual?

Trap Issue

Kristie — Fri, 11 May 2012 16:25:53 GMT

Hi, I have the following report: I need to get the records after "non-add notes:" and before "dist amount" totals. There could be any number of records before and after "non-add notes:". I have tried multiple ways and I either get all of the records or just the one after non add. Any ideas? thanks!!

Code:

000099999999 doe, steve              1  181 gd   1078.34   1078.34    784.53    6  11/10/12   99-06-22-402-005.000-999          002

  0000070002

000088888888 doe, william            1  181 gd   1039.50   1039.50    410.84    6  11/10/12   99-09-12-204-009.000-999          002

  0000070000

non-add notes:

000077777777 smith, john             1  181 gd   1778.46   1778.46   2631.86-   6  11/10/12   77-09-33-304-002.000-777          002

  0000070002

000066666666 smith, mary             1  181 gd   1270.00   1270.00   1206.69    6  11/10/12   66-10-07-255-005.000-666          002

  0000070000 



                           dist       actual dist

                          amount        amount         nbr

payee distributed     1,999,457.57    1,999,457.57   1,581

payee reversed                 .00             .00       0