Need help with a Duplicate Exclusion

4 posts / 0 new
Last post
CFE4130
Offline
Joined: 08/05/2019 - 12:59
Need help with a Duplicate Exclusion

Hi,
I've attached an example of the spreadsheet that I'm working on. I'm trying to clean up this spreadsheet so that it does NOT show instances when Procedure Code 80307 is billed with G0480, G0481, G0482, or G0483 for the same ID and Service Date. For example, lines 6 and 7 would stay and lines 8 and 9 would be removed from the results. I was trying to use duplicate exclusion function in IDEA, but I'm educated enough with scripting to figure this out. Thanks for any help.

Images: 
Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Hi CFE4130 I think you also sent this question to IDEA support so I will let them respond.

CFE4130
Offline
Joined: 08/05/2019 - 12:59

I did and the results helped, but it wasn't exactly what I was looking for. 

Anthony.Kariuki's picture
Anthony.Kariuki
Offline
Joined: 04/21/2017 - 05:14

How I would do it

  1. Import into IDEA
  2. Append a field call it 'CODE' with equation @LEFT(CLC_Procedure_Code,2)
  3. Run duplication with Criteria  Code<> GO

Hope it makes sense