Match function not working when comparing and excel source to SQL

tinkerz1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am using the function match([Table A],[Table B]), the sources of data are EXCEL and SQL, I am not getting a complete match, if I export the list boxes for Table A and Table B in excel and make a logical formala to check the cells it returns true.

As you can see the characters are the same, I have used Trim and Replace to remove spaces but still nothing. NON GENUINE: FO-FO OR FO-BO FEED ISSUE and NON GENUINE: RISK PROCESS PROBLEM don't match.

Has anyone else come across this problem?

Table A

GENUINE EXCESS

NON GENUINE: FO-FO OR FO-BO FEED ISSUE

NON GENUINE: MISBOOKING/ LATE BOOKING

NON GENUINE: OTHER

NON GENUINE: RISK PROCESS PROBLEM

TEMPORARY

Table B

GENUINE EXCESS

NON GENUINE: FO-FO OR FO-BO FEED ISSUE

NON GENUINE: MISBOOKING/ LATE BOOKING

NON GENUINE: OTHER

NON GENUINE: RISK PROCESS PROBLEM

TEMPORARY

Desc Table A	Formula
	-
GENUINE EXCESS	1
NON GENUINE: FO-FO OR FO-BO FEED ISSUE	-
NON GENUINE: MISBOOKING/ LATE BOOKING	1
NON GENUINE: OTHER	1
NON GENUINE: RISK PROCESS PROBLEM	-
TEMPORARY	1
-	-

Re: Match function not working when comparing and excel source to SQL

PabloOrtiz — Fri, 20 May 2016 16:28:50 GMT

Hi, can you attache your .qvw?.

topic Re: Match function not working when comparing and excel source to SQL in QlikView

Match function not working when comparing and excel source to SQL

Re: Match function not working when comparing and excel source to SQL