2 Replies Latest reply on Jun 26, 2018 3:06 AM by AMIT AWASTHI

    Combining Mutually Exclusive Fields

    AMIT AWASTHI

      Hi Team,

       

      I have a requirement to combine two mutually exclusive fields(Field_1 and Field_2).

       

      Field_1Field_2
      A1
      A2
      A3
      B1
      B2
      B3
      B4
      A4
      B5

       

      Final result should be like

       

      Field_3
      A1
      A2
      A3
      B1
      B2
      B3
      B4
      A4
      B5

       

      I know this can be easily achieved by SQL , but my limitation is to do it in TABLEAU only (as I don't have access to pull modified data into Tableau).

      Please help if this is possible in tableau desktop.

       

      Regards,

      Amit