Gareth Horton
July 12th, 2002, 01:27 PM
jim burke wrote:
> I'm trying to capture the **** messages and append them to the name detail. Sometime they send 1 message, sometimes 2 and so on. I need to have one detail line, with the messages as 1 2 3. I use the multiple line capture technique but it puts all of the messages in one memo field. Other techniques I try produce more than one detail line. Can this be done?
>
> 152 BURKE SAMUEL 08/06/2001 MEDICARE PART B T5440 40.00 -
> **** DA0 002 INSURED ID NO 01 SPACES EXPECTED DATA ELEMENT IS MISSING
> **** FA0 001 RENDERING PROV ID T5440 ECS PROVIDER ID NOT LOADED
> **** GC0 001 INITIAL TREATMENT DATE NOT NUMERIC THE DATE SUPPLIED IS INVALID
> 198 DUCK DONALD 08/06/2001 MEDICARE PART B T5440 65.00 -
> **** FA0 001 RENDERING PROV ID T5440 ECS PROVIDER ID NOT LOADED
> **** FA0 002 RENDERING PROV ID T5440 ECS PROVIDER ID NOT LOADED
> **** GC0 001 INITIAL TREATMENT DATE NOT NUMERIC THE DATE SUPPLIED IS INVALID
> **** GC0 002 INITIAL TREATMENT DATE NOT NUMERIC THE DATE SUPPLIED IS INVALID
> 503 FOGERTY BETHEL 08/06/2001 MEDICARE PART B T5440 40.00 -
This can be accomplished by using Monarch Pro. A "Root" Model will need to be built picking up the Account, Name, Date, etc. as Detail, export this file as an .xls file. Seperate models need to built to pick up each Code (DA0 001, DA0 002, FA0 001, FAO 002, GC0 001, GC0 002, etc.) as Detail, and also pick up the Account (152, 198, 503) as an Append. These files each need to be exported as .xls files. Bring in the "Root" .xls file as Open Database and join the "Comments" .xls file on the Account number. You will need to Export , Open Database, and Join for each. Because this requires multiple passes, it would be beneficial to check our Data Pump product. It would be a time saver for this type of situation. Please check the resulting Data below (I know it's difficult to see with the wrapping, it does work):
NUM L_NAME F_NAME DATE PART MESSAGE INFO MESSAGE INFO001 MESSAGE INFO002
152 BURKE SAMUEL 06/08/2001 MEDICARE PART B T5440 DA0 002 INSURED ID NO 01 SPACES FA0 001 RENDERING PROV ID T5440
198 DUCK DONALD 06/08/2001 MEDICARE PART B T5440 FA0 001 RENDERING PROV ID T5440 FA0 002 RENDERING PROV ID T5440
503 FOGERTY BETHEL 06/08/2001 MEDICARE PART B T5440
Dee Moore
Datawatch Corporation
Technical Support
978.441.2200
> I'm trying to capture the **** messages and append them to the name detail. Sometime they send 1 message, sometimes 2 and so on. I need to have one detail line, with the messages as 1 2 3. I use the multiple line capture technique but it puts all of the messages in one memo field. Other techniques I try produce more than one detail line. Can this be done?
>
> 152 BURKE SAMUEL 08/06/2001 MEDICARE PART B T5440 40.00 -
> **** DA0 002 INSURED ID NO 01 SPACES EXPECTED DATA ELEMENT IS MISSING
> **** FA0 001 RENDERING PROV ID T5440 ECS PROVIDER ID NOT LOADED
> **** GC0 001 INITIAL TREATMENT DATE NOT NUMERIC THE DATE SUPPLIED IS INVALID
> 198 DUCK DONALD 08/06/2001 MEDICARE PART B T5440 65.00 -
> **** FA0 001 RENDERING PROV ID T5440 ECS PROVIDER ID NOT LOADED
> **** FA0 002 RENDERING PROV ID T5440 ECS PROVIDER ID NOT LOADED
> **** GC0 001 INITIAL TREATMENT DATE NOT NUMERIC THE DATE SUPPLIED IS INVALID
> **** GC0 002 INITIAL TREATMENT DATE NOT NUMERIC THE DATE SUPPLIED IS INVALID
> 503 FOGERTY BETHEL 08/06/2001 MEDICARE PART B T5440 40.00 -
This can be accomplished by using Monarch Pro. A "Root" Model will need to be built picking up the Account, Name, Date, etc. as Detail, export this file as an .xls file. Seperate models need to built to pick up each Code (DA0 001, DA0 002, FA0 001, FAO 002, GC0 001, GC0 002, etc.) as Detail, and also pick up the Account (152, 198, 503) as an Append. These files each need to be exported as .xls files. Bring in the "Root" .xls file as Open Database and join the "Comments" .xls file on the Account number. You will need to Export , Open Database, and Join for each. Because this requires multiple passes, it would be beneficial to check our Data Pump product. It would be a time saver for this type of situation. Please check the resulting Data below (I know it's difficult to see with the wrapping, it does work):
NUM L_NAME F_NAME DATE PART MESSAGE INFO MESSAGE INFO001 MESSAGE INFO002
152 BURKE SAMUEL 06/08/2001 MEDICARE PART B T5440 DA0 002 INSURED ID NO 01 SPACES FA0 001 RENDERING PROV ID T5440
198 DUCK DONALD 06/08/2001 MEDICARE PART B T5440 FA0 001 RENDERING PROV ID T5440 FA0 002 RENDERING PROV ID T5440
503 FOGERTY BETHEL 06/08/2001 MEDICARE PART B T5440
Dee Moore
Datawatch Corporation
Technical Support
978.441.2200