common value should show in both wild match

[sagarrahul]

hiii community

want a help from u

=if(WildMatch(ICD_CODE_LEVEL1_org,HOSPITAL_CODE,'T02.9','T02.8','T02.7','T02.6','T02.5','T02.4','T02.3','S43.3','S43.2','S43.1','S43.0','S42.9','S42.8','S42.7','S42.4','S42.3',

'S42.2','S42.1','S42.0','S62.8','S62.7','S62.6','S62.5','S62.4','S62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4',

'S32.3','S32.2','S32.1','S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7','S02.6'),'Agent Code A',

=if(WildMatch(ICD_CODE_LEVEL1_org,HOSPITAL_CODE,'62.3','S62.2','S62.1','S62.0','S22.8','S22.5','S55.9','S55.8','S55.7','S55.1','S55.0','S32.7','S32.5','S32.4',

'S32.3','S32.2','S32.1','S32.0','S52.4','S52.3','S52.2','S52.1','S52.0','S93.2','S92.9','S92.7','S92.5','S92.4','S92.3','S92.2','S92.1','S92.0','S02.9','S02.8','S02.7','S02.6'),'Agent Code B'))

this are my two wildmatch

in this these wildmatch some codes are repeated in both of wildmatch so its not taking both wildmatch .

now what i want is i want to used "hospital_code" in my wildmatch as i have taken bt its not getting me right

then where should i use hospital_code it so that i repeated value can come on basic of "hospital_code"

[Gysbert_Wassenaar]

this are my two wildmatch

in this these wildmatch some codes are repeated in both of wildmatch so its not taking both wildmatch .

now what i want is i want to used "hospital_code" in my wildmatch as i have taken bt its not getting me right

then where should i use hospital_code it so that i repeated value can come on basic of "hospital_code"

Can you try to explain that again in other words? Please use short sentences and proper punctuation. Ask the help of a friend or coworker if you're not sure about how to write something in English.

[sagarrahul]

there are two wildmatch

in this there are some codes which are there present in both of the wildmatch .

eg :

this code are '62.3','S62.2','S62.1','S62.0','S22.8' which are coming in both wild match

now what i want is that when above repeated code come it should show is vale both in ie as 'Agent Code A', or 'Agent Code b', as in my wildmatch

[sagarrahul]

output should me this

        as 'S62.2' and 'S22.8' are present in  both the wildmatch then acoording to there "hospital_code" make them in differnt group like 'Agent Code A and 'Agent Code B'

AGENT_FULL_NAME	POL_AGENT_CODE	HOSPITAL_NAME	HOSPITAL_CODE	CLM_LEVEL_OF_CARE	ICD_CODE_LEVEL1_org	contains
HE DIRECT 1000 -3420	200278133519	AASHIRVAD HOSPITAL & RESEARCH CENTRE	HEGIC-HS-46134	Secondary	S22.8'	Agent Code C
HE DIRECT 1000 -3420	200278133519	AASHIRVAD HOSPITAL & RESEARCH CENTRE	HEGIC-HS-46134	Secondary	S62.2	Agent Code B
HE DIRECT 1000 -3420	200278133519	AASHIRVAD HOSPITAL & RESEARCH CENTRE	Total
HE DIRECT 1000 -3420	200278133519	AASTHA HOSPITAL	HEGIC-HS-02071	Secondary	S62.2	Agent Code C
HE DIRECT 1000 -3420	200278133519	AASTHA HOSPITAL	HEGIC-HS-02071	Secondary	J22	Agent Code B
HE DIRECT 1000 -3420	200278133519	AASTHA HOSPITAL	HEGIC-HS-02071	Secondary	S22.8'	Agent Code C
HE DIRECT 1000 -3420	200278133519	AASTHA HOSPITAL	HEGIC-HS-02946	Secondary	A90	Agent Code B
HE DIRECT 1000 -3420	200278133519	AASTHA HOSPITAL	HEGIC-HS-02946	Secondary	R50.9	Agent Code C

now any1 can help me in this