Join Tables Not Working in Studio

[jpreziuso]

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)]

@jpreziuso

it is only trimming the column names

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.

[jpreziuso]

I fixed this issue by trimming the table beforehand following the steps in this post:

Automatically make .trim () on a datatable in all rows and columns

Hello, first excuse me for english, i have a datatable with more than 100k lines and needed to do .trim () on all rows and columns and if doing foreachrow takes too long, is there a faster and automated way? Thanks in advance.