hello
I am running lookup task inside dataflow for identifying genuine city names. I am taking a TEST table and testing values against a base table (contains correctly spelled city names).
However, I am not getting expected results. There are some cities which are spelled same in both tables(Base table & TEST table) But still, I am not getting them in result table.
How can i troubleshoot it? please suggest. Do I need to use RTRIM & LTRIM function on city name?
Thanks