Apologies if this has been requested in the past. I would like a case insensitivity checkbox on the join tile. In the example below, I have created two datasets. In dataset2, I have a list of words in varying cases: lower, upper, and proper.
If I join the datasets, I get different results based whether the words in dataset1 match the case in dataset2. We only get a match if the joined fields have the exact same case. I know I can use a tile to lower or upper both sides before matching, but that creates extra tiles on an already large ETL. I would like a setting that indicates - join on these fields regardless of the case. So that "Apple" and "apple" match. Or "APPLE" and "apple" match.
