6 Replies Latest reply: May 15, 2014 10:08 AM by elginreigner _ RSS

    Filtering out redundant inputs (or filtering based on summary)

    MonUserCJ _

      Hey all,

       

      I have a table in Monarch imported from a CSV file that lists fees for different medical procedures. The medical procedures are represented using 5-character strings called CPT codes. The issue is, the table lists some procedures (perhaps 10) multiple times, and thus certain procedures have multiple fees listed.

       

      So, for example, I have this:

       

      PROC1, $5

      PROC1, $6

      PROC2, $4

      PROC2, $8

      PROC3, $2

      PROC4, $3

      PROC5, $8

      PROC5, $7

      PROC6, $3

       

      I am trying to update a SQL table based on these fees, but it's problematic if the CPT codes in the table and the CPT codes in the fee table don't match one-to-one. I was wondering if there is a way to exclude the procedures that are listed multiple times in a somewhat automated fashion (perhaps based on the number of times they appear in a column as based on a Monarch summary).

       

      Does anyone have any insight as to how I might go about doing this? I would appreciate any advice anyone can give.