Feature request #22032

Allow join fields to use expressions

Added by Admire Nyakudya almost 5 years ago.

Status:Open
Priority:Normal
Assignee:-
Category:Attribute table
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:29846

Description

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

join.png (78.4 KB) Admire Nyakudya, 2019-05-09 01:07 PM

Also available in: Atom PDF