I have to compare the values present in two columns. But the columns are located in different tables. e.g. I have to compare values of Column A with the values of Column B. Column A is present in Table A whereas Column B is present in table B. How do I compare them in the script?
I think you can bring both field into a temp table, from there you can then use IF statement to check field value and create a YES/NO field. Finally left join or ApplyMap the new field back to any of the tables.