Forum Discussion

KPMEE's avatar
KPMEE
Frequent Visitor
3 years ago
Solved

Linking Tables Column Names with different punctuation

Hello,   I have different sources, where the same names appear, but the names are appear slightly different:   Table 1: Collumn Names: John.Doe Table 2: Collumn Names: john doe   How would I l...
Need Help
  • KPMEE's avatar
    KPMEE
    3 years ago

    I ended up adding two new columns to both tables with this formula:

    NewNames = LOWER(SUBSTITUTE(Table[Names], ".", " "))
KPMEE's avatar
KPMEE
Frequent Visitor
3 years ago

I ended up adding two new columns to both tables with this formula:

NewNames = LOWER(SUBSTITUTE(Table[Names], ".", " "))