Trying to delete parent NM1 segment - subscriber name NM1*IL, when claim has NM1*QC segment - patient

[asujata-1234]

SBR*P**125000******MC~
NM1*IL*1*Testlast1*Testfirst1****MI*ZECM12541853~
NM1*PR*2*BLUECARE*****PI*GED00217P~
HL*13*12*23*0~
PAT*19~
NM1*QC*1*Testlast1*LAZARUS~
N3*243 COBB ROAD~
N4*JACKSON*TN*38305~
DMG*D8*20210618*M~
CLM*241114-01*147***11:B:1*Y*A*Y*Y~

My code is deleting patient - (NM1QC1Testlast1LAZARUS~). I need to delete NM1IL1Testlast1Testfirst1***MIZECM12541853~ Any advice is greatly appreciated.

var PatientFirstName = new Array();
var counter = 0;
'''javascript
for(var i = 0; i < msg['SBR'].length(); i++) {
//	if(msg['SBR'][i]['SBR.01']['SBR.01.1'].toString() == 'P') {
	//for(var j = 0; j < nm1.length(); j++) {
		
		
				for each(nm1 in getSegmentsAfter(msg, msg['SBR'][i], 'NM1')) {
					//msgNM2 = (nm1['NM1.01']['NM1.01.1'].toString());

							if (nm1['NM1.01']['NM1.01.1'].toString() == 'QC') {
								delete nm1[j]
								PatientFirstName[counter] = (nm1['NM1.04']['NM1.04.1'].toString());
								counter += 1;
							channelMap.put("PatientFirstName",PatientFirstName);}
								
							else if (nm1['NM1.01']['NM1.01.1'].toString() == 'IL') {
								
								//logger.info("Patient count is=: " + count); 
								PatientFirstName[counter] = (nm1['NM1.04']['NM1.04.1'].toString());
								counter += 1;
							channelMap.put("PatientFirstName",PatientFirstName);
							logger.info("PatientFirstName is=: " + PatientFirstName); 
				}}}

[tonygermano]

I think this is what you were asking for?

For each subscriber, if there is an NM1 segment with QC qualifier, then delete the NM1 segment(s) with IL qualifier.

function deleteInDocument(element) {
    delete element.parent().children()[element.childIndex()]
}

for each (var sbr in msg.SBR) {
    var nm1s = getSegmentsAfter(msg, sbr, 'NM1')
    if (nm1s.some(nm1 => nm1['NM1.01']['NM1.01.1'].toString() == 'QC') {
        nm1s.filter(nm1 => nm1['NM1.01']['NM1.01.1'].toString() == 'IL').forEach(deleteInDocument)
    }
}

[asujata-1234]

Not sure seems to be not working with the code posted above gives me null for the first name as the segment is deleted and it is deleting for all IL and QC segment when I processed sample file attached above

[asujata-1234]

var PatientFirstName = new Array();
var counter = 0;

var PatientFirstName = new Array();
var PatientQC = new Array();
var counter = 0;
var count = 0;
var FinalPatientFirstName = new Array();
var finalcount = 0;
for(var i = 0; i < msg['SBR'].length(); i++) {

			
				for each(nm1 in getSegmentsAfter(msg, msg['SBR'][i], 'NM1')) {
							if (nm1['NM1.01']['NM1.01.1'].toString() == 'QC') {
								
								PatientFirstName[counter] = (nm1['NM1.04']['NM1.04.1'].toString());
								counter += 1;
								PatientQC[count] = (nm1['NM1.01']['NM1.01.1'].toString());
								count += 1;
								
								
							channelMap.put("PatientFirstName",PatientFirstName);
							channelMap.put("PatientQC",PatientQC);}}
				for each(nm1 in getSegmentsAfter(msg, msg['SBR'][i], 'NM1', true))	{
							 if (nm1['NM1.01']['NM1.01.1'].toString() == 'IL') { 													
								PatientFirstName[counter] = (nm1['NM1.04']['NM1.04.1'].toString());
								counter += 1;
								PatientQC[count] = (nm1['NM1.01']['NM1.01.1'].toString());
								count += 1;
                                                        channelMap.put("PatientFirstName",PatientFirstName);							
							channelMap.put("PatientQC",PatientQC);}

								
							 }
				}

[tonygermano]

Your discussion title is "Trying to delete parent NM1 segment - subscriber name when claim has NM1*QC segment - patient." In your initial post you said your are deleting the NM1 segment with QC, but you need to delete the one with IL.

I explained that my code deletes the NM1IL segment for each subscriber where there is a NM1QC segment.

If you need to do something with the names or delete on some other condition that was not described in the problem, and I don't understand what your goal is.

[asujata-1234]

I am sorry, I am trying to delete NM1IL when when claim has NM1QC. Thank you so much for helping. I am trying to collect patients first and last name for all claims. I did attach sample message on link #5023 .
For each subscriber, if there is an NM1 segment with QC qualifier, then delete the NM1 segment(s) with IL qualifier. I am trying to transform patient info (patient first and last name), for example (NM1IL1TLast1TFirst1MIY9968001~). when patient has subscriber meaning there is NM1QC qualifier in the claim along with some claims with NM1IL qualifier, subscriber is the patient. I have 15 claims in the sample message. I have only one claim that has QC qualifier. Basically delete first name of the 6th claim TFirst6 with qualifier IL since it has QC qualifier with first name QC_TFirst6.

Processed sample file-actual
["TFirst1","TFirst2","TFirst3","TFirst4","TFirst5","TFirst6","QC_TFirst6","TFirst7","TFirst8","TFirst9","TFirst10","TFirst11","TFirst12","TFirst13","TFirst14","TFirst15"]

Expected results

["TFirst1","TFirst2","TFirst3","TFirst4","TFirst5","QC_TFirst6","TFirst7","TFirst8","TFirst9","TFirst10","TFirst11","TFirst12","TFirst13","TFirst14","TFirst15"]

I do not need TFirst6 from NM1IL segment NM1IL1TLast6TFirst6**MIZECM12541853~ which is 6th claim in that file.

[asujata-1234]

With this code I was able to get the first names of patient with both IL and QC qualifier. Now I have two arrays with PatientFirstName and PatientQC (qualifiers). I want to create hash table and delete the qualifier QC and corresponding name either in source or destination. I did try but did not work yet.

var PatientFirstName = new Array();
var PatientQC = new Array();
var counter = 0;
var count = 0;
var FinalPatientFirstName = new Array();
var finalcount = 0;
for(var i = 0; i < msg['SBR'].length(); i++) {

		
		
				for each(nm1 in getSegmentsAfter(msg, msg['SBR'][i], 'NM1')) {
					//msgNM2 = (nm1['NM1.01']['NM1.01.1'].toString());

							if (nm1['NM1.01']['NM1.01.1'].toString() == 'QC') {
								PatientFirstName[counter] = (nm1['NM1.04']['NM1.04.1'].toString());
								counter += 1;
								PatientQC[count] = (nm1['NM1.01']['NM1.01.1'].toString());
								count += 1;
								//PatientQC.deleteInDocument;
								//delete PatientQC[j];
								//delete PatientFirstName[j];
								
							channelMap.put("PatientFirstName",PatientFirstName);
							channelMap.put("PatientQC",PatientQC);}}
				for each(nm1 in getSegmentsAfter(msg, msg['SBR'][i], 'NM1', true))	{
								
							 if (nm1['NM1.01']['NM1.01.1'].toString() == 'IL') { 
								
								
								PatientFirstName[counter] = (nm1['NM1.04']['NM1.04.1'].toString());
								counter += 1;
								PatientQC[count] = (nm1['NM1.01']['NM1.01.1'].toString());
								count += 1;
							//	PatientQC.deleteInDocument;
							//	PatientFirstName.deleteInDocument;
							//delete nm1[j];
							channelMap.put("PatientFirstName",PatientFirstName);							
							channelMap.put("PatientQC",PatientQC);}

						//	if (PatientQC=='QC'){
								//delete PatientFirstName(i+1);
								///PatientFirstName[finalcount] = (PatientFirstName);
								//finalcount += 1;
							//channelMap.put("FinalPatientFirstName",FinalPatientFirstName);

							
							logger.info("PatientQC is=: " + PatientQC); }
				}