Join Tables Not Working in Studio

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

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:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.