4 Replies Latest reply on Mar 8, 2016 9:06 AM by MICHAEL CARIDI

    Extract Data from a Column into Multiple Fields

    MICHAEL CARIDI

      Hi Everyone -

       

      First time post here.

       

      Here's the issue, I direct connect tableau to our data warehouse solution, Netezza, which might prove to be valuable information.  After I connect to the table, the data I am interested in is stored in two fields: NCVREPORTLABEL & NVCANSWER.  What I need is when NVCREPORTLABEL = "Agent Full Name" & "Compliance Adherence" to provide the corresponding value from NVCANSWER.  I have tried IF statements without success.  Ideally I would like the data to appear like below:

       

      IEVALID

      AGENT FULL NAME

      COMPLIANCE ADHERENCE

      818515

      Ramirez, Juan Carlos

      Pass - Successful Transaction

      818520

      Perez, Domingo 248041

      Pass - Successful Transaction

       

      However the best I have gotten is:

      IEVALID

      NCVREPORTLABEL

      NVCANSWER

      818515

      AGENT FULL NAME

      Ramirez, Juan Carlos

      818515

      COMPLIANCE ADHERENCE

      Pass - Successful Transaction

      818520

      AGENT FULL NAME

      Perez, Domingo 248041

      818520

      COMPLIANCE ADHERENCE

      Pass - Successful Transaction

       

      Appreciate any feedback! Thanks!  Sample data attached.