Hi Marco. Thank you for quick response. Basically I need to compare all values with each other against one Id value and show its comparison accuracy percent.
There is requirement to compare name string for given Id value in rowwise data and show accuracy % based on comparison. Have used LevenshteinDist script function. It calculates correctly for column wise data and if word sequence in both columns is same. Eg. Column1: Ram Kumar Prasad, Column2: Ram Kumaar Prasad. However for scenario, Column1: Ram Kumar Prasad, Column2: Prasad Kumaar Ram, percentage is vey low. We require this for rowwise data as specified in revised attachment (String_compare_v1.xlsx).
