I am attempting to join two tables and cannot get it to work using the following activity
However, when I load the tables into SQLite and run an equivalent join query, it works as expected
It seems like in UiPath, it is only trimming the column names whereas in SQLite is trimming the data in the columns (which is the correct outcome).
Any thoughts as to why? Thanks