Calculate confidence score for matching string

(0) Share

Report

Posted on by PowerUser0

240

Hi Folks,

PFB, Attached is the screenshot!

I am trying to match string in A2 with B2 and find the matching confidence score in column C2. How can we perform this scenario in cloud flow?

@ekarim2020 @abm

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,979 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @PowerUser0

Didn't really understood with the sample given data? Could you please explain more?

Thanks

Was this reply helpful? Yes No

PowerUser0

240 on at

Like (1)

Report

Copy link

Link copied!

Hi @abm so there are two columns in the excel sheet right, for eg. I have to compare "(GMT+12:00) Fiji Time (Pacific/Fiji)" with "(GMT+12:00) Fiji Time (Fiji)" in both the strings, there is a difference of word Pacific, so I need to calculate how much percent it matched

Examples are below:

(GMT+03:00) Israel Daylight Time (Asia/Jerusalem)	(GMT+03:00) Israel Daylight Time (Asia/Jerusalem)	98
(GMT+05:30) India Standard Time (Asia/Calcutta)	(GMT+05:30) India Standard Time (Asia/Calcutta)	97.92
(GMT+08:00) Hong Kong Time (Asia/Hong_Kong)	(GMT+08:00) Hong Kong Time (Asia/Hong_Kong)	97.73
(GMT+08:00) Hong Kong Time (Asia/Hong_Kong)	(GMT+08:00) Hong Kong Time (Asia/Hong_Kong)	97.73
(GMT+12:00) Fiji Time (Pacific/Fiji)	(GMT+12:00) Fiji Time (Fiji)	75.68
(GMT+12:00) Fiji Time (Pacific/Fiji)	(GMT+12:00) Fiji Time (Fiji)	75.68
(GMT+12:00) Fiji Time (Pacific/Fiji)	(GMT+12:00) Fiji Time (Fiji)	75.68
(GMT-06:00) Mountain Daylight Time (America/Denver)	(GMT-06:00) Mountain Daylight Time (Denver)	82.69
(GMT-06:00) Mountain Daylight Time (America/Denver)	(GMT-06:00) Mountain Daylight Time (Denver)	82.69
(GMT-06:00) Mountain Daylight Time (America/Denver)	(GMT-06:00) Mountain Daylight Time (Denver)	82.69
(GMT-07:00) Pacific Daylight Time (America/Tijuana)	(GMT-07:00) Pacific Daylight Time (America/Tijuana)	98.08
(GMT-07:00) Pacific Daylight Time (America/Tijuana)	(GMT-07:00) Pacific Daylight Time (America/Tijuana)	98.08
(GMT-07:00) Pacific Daylight Time (America/Tijuana)	(GMT-07:00) Pacific Daylight Time (America/Tijuana)	98.08

Was this reply helpful? Yes No

PowerUser0 240 on at

Like (0)

Report
Copy link

Link copied!

@Hardesh15 @ScottShearer @ekarim2020 Please help me on this

Was this reply helpful? Yes No
Verified answer

abm abm 32,979 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @PowerUser0

Thanks for the discussion. So here are the options:

1. Use the flow length and substring expressions to do a comparison but it will be very slow for the overall execution.

2. You could utilise C# or some other language to host an Azure function and call from flow using HTTP.

3. Have a look on the AI builder.

Thanks

Was this reply helpful? Yes No