Equals (Strict) function
Is there any documentation on the functions? I am looking for explanation for Equals (Strict) Function. I have a strange result. The function seems to work randomly. Here is an example:
ADDR1 STREET ADDR1_Chk
401 UDAYBHANU APTS, 401 UDAYBHANU APTS, false
222 GETTY AVE 222 GETTY AVE true
When I check the data in Excel, excel returns true for both rows, but Aperture returns false for the first one. There are multiple rows like this. (I am checking the values in Input file vs values stored in SAP after upload).
Anyone faced this issue? Is there any suggestion to fix this reliably? Is there another function that I can use reliably?
Thanks,
-George
Answers
-
Hi George
In the documentation you will find information on each Function:
Equals - Checks the input value for equality with the comparison value(s), based solely on appearance which is then standardized, i.e. ignoring any differences in data type and non-alphanumeric characters.
Equals (Strict) - Checks the input value for strict equality with the comparison value (i.e. the data type has to also match).
1 -
Hi Josh, Thanks for the link! I could not find it in my search. I appreciate it.
I shall use Equals instead of Equals (Strict) for now. But it does not explain what is different in the example I gave. If Equal ignores all special characters like hyphen (-) that may not be a good check. But it looks like Equals (Strict) is unreliable.
0 -
I assume these values are different in some way, but it is hard to say from the information provided. For example there is a leading space before 401? Possibly one of the space characters is actually a non-breaking space etc,
I would try the Functions Trim, Remove unprintable characters, Remove invisible characters, Remove whitespace
If it is still not clear we can help investigate if you can export to a dmx file https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/monitor-data-and-troubleshoot/migrate-metadata/#exportfromaspace and share it in a support ticket https://docs.experianaperture.io/more/contact-support/
Thanks
0