i need compare the data and give the output in terms of percentage
Code: Select all
Source data
empid,ename,eaddess,sal
"1000","abcd","road7 stree2","1000"
"2000","dddd","roadno2 streeno12","2000"
Reference data
empid,ename,eaddess,sal
"1000","abcd","road7 stree2","1000"
"2000","dddd","road2 stree12","2000"
Output
empid,ename,eaddess,sal,percentageofeaddress
"1000","abcd","road7 stree2","1000",100%
"2000","dddd","road2 stree12","2000",80%
the percentageofeaddress column should give the difference of the column eaddress.
Based on the forums, i have tried with function compare, but I am unable to get the direct function which give the percentage of variation of the column
Any help greatly appreciated.
Thanks -suresh