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
postwick
(Paul Ostwick)
2
That’s because “Some String”.Trim is an expression that trims the string, not the value within a column named by the string.
If you need to trim values, do that separately before attempting the Join.
1 Like
I fixed this issue by trimming the table beforehand following the steps in this post:
system
(system)
Closed
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.