String compare percentage

miteshpanchal-2 — Wed, 25 May 2022 14:14:50 GMT

Hi All,

There is requirement to compare name string for given Id value in rowwise data and show accuracy % based on comparison.

Re: String compare percentage

MarcoWedel — Wed, 25 May 2022 20:55:47 GMT

what is your expected result given this test data?

how is accuracy defined?

Re: String compare percentage

miteshpanchal-2 — Thu, 26 May 2022 05:11:55 GMT

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).

topic String compare percentage in App Development

String compare percentage

Re: String compare percentage

Re: String compare percentage