I am trying to check the values of two tables if they match.
I tried the join table activity, but the joined table does not have the DT1 value.
I think the data types are different so did not joined the values?
I checked the data type of each column and i got:
Shipping note column of DT1 : System.Object
Delivery column of DT2 : System.String
Also I tried to do Vlookup using the Lookup Data table activity but it did not work.
The error says cannot convert Double to String at the Get Row Item so I tried to convert Double to String but got error.