Skip to Content
0
Former Member
Apr 19, 2010 at 11:10 AM

How to find unique rows that don't have counterpart using Excel/MSSQL?

73 Views

Dear All,

I need to extract unique rows that don't have the counterpart in Excel or in MSSQL. I pasted a sample data below (from MS SQL select):

ACCOUNT,CATEGORY,ENTITY,PRODUCT,TIMEID,SIGNEDDATA,CONTRACTD,DATASRC,SCOUNTRY,UNITY,SEGMENT,BANDWIDTH,DATATYPE,INPUTCURRENCY

400411,FORECAST_V5,E2100,P1030,20100100,5500,D0001000,DS_10,AU,NOUNITY,SEG_22,NOBWT,C_INPUT,AUD

400411,FORECAST_V5,E2100,P1030,20100100,1100,D0001,DS_10,PH,NOUNITY,SEG_22,NOBWT,C_CONVERTED,USD <<missing counterpart>>

400411,FORECAST_V5,E2100,P1030,20100100,4867.26,D0001000,DS_10,AU,NOUNITY,SEG_22,NOBWT,C_CONVERTED,USD

Our custom dimension DATATYPE identifies which data/row is entered (imported using Data Manager or an input template) and which record is calculated. Normtally, the FxTrans will use the C_INPUT records to create C_CONVERTED records. But now, we have a situation where we have some C_CONVERTED records that are not the results from C_INPUT convertion (we suspect it's user error).

How can I use Excel or SELECT statement to extract rows of C_CONVERTED that are not from the result of a calculation?

THanks.

=Hamdy