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

      Hi,

       

      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.