8 Replies Latest reply: Dec 21, 2017 1:49 AM by Divyanshi Bansal RSS

    I want to match two columns with same name but differ by uppercase?

    Divyanshi Bansal



      I have two tables A and B. A has Customer Group while B has Customer Group Name.

      I have customers of A only appear in my pivot table.

      Since I need data from B table also but corresponding to only customers of A.


      How to match customers of A and B ?


      I am using


      if ([Customer Group]=CUSTOMER_GROUP_NAME , [Customer Group])


      But this gives only customers in Abbreviation like BCGH but not be able to map like 2degrees.


      Kindly help.