2 Replies Latest reply: Nov 3, 2014 1:46 PM by lcwalker _

Monarch 10.5 Abosolute Reference

Still on the old software, so I hope someone can help.  Is it possible to do an abosulte row reference for a 'cell' value in Monarch 10.5?  For example.  I want to compare the value in Row(1) "Patient Number" with the value in Row(2) "Patient Number".  If they are the same I'd like to do some calculations with a Forumula Based calculated field.  This is done pretty easily in Excel, so I would imagine Monarch can do it as well.  Please let me know if i need to clarify.

• Re: Monarch 10.5 Abosolute Reference

Hello LC,

Yes, you can, but not as easily as in Excel. Some techniques that might help are in this webinar: http://www.datawatch.com/video/invisible-data-advanced-techniques-for-datawatch-modeler/

Do you want to compare row(N) always with row(N-1)? What do you do with Row 1? Or if you want to compare Row(N) with Row(N+1), what do you do with the last row?

Essentially, the easiest technique is to get the filtered and sorted data into a table, add two calculated fields (Rowno() and Rowno()+1) export it as an Access MDB file, then make an

external lookup to this, joining Rowno() with Rowno()+1 or vice versa.

But assume you'll get a null lookup at either the top or the bottom of your data (just like you would in Excel, BTW).

Best wishes,

Olly

• Re: Monarch 10.5 Abosolute Reference

Ah, my good friend Olly. Long time no see. Thanks for the response. It would be Row(N) with Row(N-1), starting at Row(2) with null values in the first row; data sorted by patient number then admit date. I'm trying to track readmissions by comparing the discharge date of Row(N) with the admit date of Row(N-1). I'll have a look at the webinar and see where it takes me.