Hello
i was trying to join two tables with the link function but am having issues with the Case's for the fields im joining on.
one is Firstname.LASTNAME@company.com and the other table has firstname.lastname@company.com (all lower case)
is there a way to ignore case and focus on the content/values
i already tried to specify Upper {table1} = Upper {table2} in the formula workshop with no success
i was trying to join two tables with the link function but am having issues with the Case's for the fields im joining on.
one is Firstname.LASTNAME@company.com and the other table has firstname.lastname@company.com (all lower case)
is there a way to ignore case and focus on the content/values
i already tried to specify Upper {table1} = Upper {table2} in the formula workshop with no success