3 Replies Latest reply on Aug 23, 2018 7:47 AM by Zhouyi Zhang

    Show qualifier values as columns

    Daniël Boeije

      I'm currently facing a challenge with creating a table view, as one of the tables stores multiple reference qualifiers in the same column with corresponding values in the column next to it - similar to below example. In order to replicate the Excel version of the dashboard I need those values (or at least a specific few) to be showing as a column, showing the values on the right in the rows accordingly. I was wondering if someone else faced a similar challenge, as there is actually some good logic in storing the data this way.

       

      I have already tried to use a custom SQL query, however I'm looking for a more native Tableau alternative to display it correctly.

       

      Table: Order_details

      Order IDOrder Reference QualifierReference Value
      100000001CARRIERPostNL
      100000001TRACKING3STUNM006476996
      100000001SERVICEStandard
      100000002CARRIERPostNL
      100000002TRACKING3STUNM006476997
      100000002SERVICEStandard
      100000003CARRIERTNT
      100000003TRACKING123456789
      100000003SERVICEExpress

       

      Expected result:

      Order IDCARRIERTRACKINGSERVICE
      100000001PostNL3STUNM006476996Standard
      100000002PostNL3STUNM006476997Standard
      100000003TNT123456789Express