I am working on an SAP BW on HANA system version 7.4 SP09, where I faced a problem during implementing the FUZZY logic. Because of certain restrictions I am not able to do this in a procedure in SAP HANA directly. My idea was to do it in a Transformation in the BW as a SAP HANA Expert Script.
My goal is to clean duplicates of material. If I do this via SELECT in SAP HANA (see coding below), it is working fine.
Select score() as Score, “material”
WHERE contains((text), 'phone', FUZZY(0.7))
ORDER BY text
My coding – where I want to find duplicates for materials in the transformation - looks like this:
Select score () AS Score, *
WHERE CONTAINS ("field_name", 'phone',FUZZY(0.7));
outTab = select
Score AS “percentage”
FROM :inTab ;
The error occurs with a Syntax problem that I can’t reach the table and the schema/table has to declared in the method. For an intern tables there has to be added a ‘:’.
Did someone know the correct syntax to implement the FUZZY logic?