7 Replies Latest reply on Sep 6, 2018 6:27 PM by Hari Ankem

    How to handle string when joining excel and table from the database

    Grace Raj

      Hi All,

       

      I am joining with the field called 'State' from excel and 'State' field from table. The sameple  value is

       

      State (Excel)

      New england

      Connecticut

      maine

      massachusetts

      new Hampshire

      Rhode island

       

       

      State (Table)

       

      new england

      connecticut

      maine

      massachusetts

      new hampshire

      rhode island

       

       

      Does tableau will take care of the case sensitive and join the field..or do I have to specify any function to make is even value..

      Can you please tell what function do I have to apply (Upper,Lower) and where...