Ignore Case sensitive data in a table

[Anonymous]

Hi All,

I have created a third table in query editor to join 2 other tables. However I would like to ignore the case senstive data.

for eg: mdf and MDF, demand Generation & Demand Generation. How do i acheive this and make sure that whenever a user enters the data it records as one entry? 

[edhans]

You can transform the data using Text.Lower() or use the menu on the Transform tab, Format, lowercase. (or upper if you like.) Then do your comparisons, merges, or show distinct values.

[Anonymous]

Hi,

I converted the data to upper case. I still do see two values of the data that was incorrectly entered.

and also once convereted to uppercase will i be able to join it to other tables(as they are in normal format).

[edhans · Accepted solution]

The transformation to UPPER needs to be before you do the Table.Distinct command.

Also, you may need to do a TRIM as well in the Transform menu. You could have "MDF" and "MDF " for example with trailing spaces.

If you still see dupes, do a CLEAN in the Transform menu.

Then do your Table.Distinct() command.