Hi @Abisheck_Canary,
Can you clarify you definition of match? Does it need to match the exact value of column1 or can it match against part of the value as well?
In case of the first scenario you can use something like the example below.
In an update row I use the following expression in a new percentage column.
This expression uses a indexOf to check if the value of column1 is is found in column2. If that is the case (not equals to -1). The length of both values are converted to float values and used in a div calculation and formatted as a percentage value via formatnumber with the P2 format.
if(equals(indexOf(item()?['column2'], item()?['column1']), -1), 0, formatnumber(div(float(length(item()?['column1'])), float(length(item()?['column2']))), 'P2'))
This would result in the following percentages
