Hi ALL,

I have below example

Code:

Code:

INPUT 1 (i/p 1)|INPUT 2 (i/p 2)|OUTPUT (o/p)
Bharat Bazar|Bharat Bazar|True Positive
Binny's Sales|<BLANK>|False Negative
<BLANK>|Binny's|False Positive
<BLANK>|<BLANK>|True Negative
Bharat bazar|Bharat|True Positive
binny's|binny|True Positive

where in the o/p should be either of the 4 based on the scenarios on first 2 columns which is self explainatory.

If the column 1 sub string is present in column 2 then it should be True Positive.

After all of these, It should give me the Percentage of all the scenarios based on the total number of records


My first 2 columns i.e. i/p1 and i/p2 are the inputs and the o/p is the result i'm generating based on i/p1 and i/p2.

i/p can be any of the strings as well as blank, similarly i/p2 can be string, sub string of i/p1 or blank.

o/p column should be generate by us. based on i/p1 and i/p2

<BLANK> is just a blank space, I gave it for meaningful representation, | is the delimiter used.