Feature request #22032
Allow join fields to use expressions
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||29846|
I have two tables (Table A, Table B) with columns name. I needed to use these columns to create my join but once I join them I realize that they are no records that have joined because of the differences between title case for the two columns. Table A contains values in Uppercase and table B contains data in lowercase. It would be nice to include the option to use an expression on the target field/join field when doing a join ie
Table A has name = UpperCase
Table B has name = Lowercase so when we do the join we could use the expression Upper(name) on the target field.
This would prevent having to edit the raw data by updating it or creating a new virtual field or using SQL for people who are not good in SQL (virtual layers).