Request to resolve my challenging work.

[#1]

Hi All,

I have an excel file (Attached) which need to be loaded in QV in such a way that all the sub domain  which has domain engagement status as c (C represents 'current')in any account and there is an opportunity (domain engagement status as 'O' ) in another account.

The result must be given below

Sub Domain	Functional Area	Account	Domain Engagment Status
Payer	Membership	Kaiser	C
Payer	Membership	United Health Group	C
Payer	Membership	Humana CarePlus	C
Payer	Benefits Management	Humana CarePlus	C
Payer	Provider Management	United Health Group	C
Payer	Provider Management	Humana CarePlus	C
Payer	Medical Management	Humana CarePlus	O
Payer	Claim Adjudication	Humana CarePlus	C
Payer	Finance	Kaiser	C
Payer	Finance	Humana CarePlus	C
Payer	Underwriting & Actuaries	Humana CarePlus	O
Payer	Customer Service	Humana CarePlus	O
Payer	Customer Service	NEHEN and Rx Gateway	C
Payer	Sales & Marketing	Kaiser	C
Payer	EDI (HL7/X12)	Kaiser	C
Payer	EDI (HL7/X12)	Humana CarePlus	C
Payer	EDI (HL7/X12)	NEHEN and Rx Gateway	C
Payer	Claim Fraud Detection	Truven	C
Payer	Claim Audits	Truven	C
Payer	Health Plans	Truven	C
Payer	Analytics	Truven	C
Life Sciences	Research & Development	Pfizer	O
Life Sciences	Drug Discovery	Pfizer	O
Life Sciences	Clinical Trials	Pfizer	O
Life Sciences	Medical Info	Pfizer	O
Life Sciences	Quality & Manufacturing	Pfizer	O
Life Sciences	Quality & Manufacturing	Glenmark Generics	C
Life Sciences	Quality & Manufacturing	Pacific Biosciences	O
Life Sciences	Sales & Marketing	Pfizer	O
Life Sciences	Legal / Corporate	Pfizer	O

Thanks for you reply.

[suresh_rawat]

HI Prajeesh,

Kindly refer the attached image and qvw file.

Hope it will work for you.

Regards

Suresh Rawat