2 Replies Latest reply on Jun 14, 2016 1:37 AM by Anh Ho

    Can I teach Tableau which value line to choose from?

    Anh Ho

           Hi all,

           I'm wondering if I can teach Tableau which value line to choose from. My data from SQL server often have 3 lines. The first line, code SA, is the initial data input. However, if the initial data entered is wrong, the system gives 2 lines, code CS, to correct the wrong data. The first CS line will be indicate as -(wrong data), the second line CS line will be the right data. An example of it is:

      Order no.
      Order codeQuantityUOMDate
      8987503SA98.85MT02/06/2016
      8987503

      CS

      -98.85MT02/06/2016
      8987503CS97.85MT02/06/2016
      7869372SA1000.95MT03/06/2016
      7869372CS1000.95MT-03/06/2016
      7869372CS1000.95MT04/06/2016
      8975983SA100.85MT05/06/2016

          I want Tableau to choose SA code value if there is no CS line. But if there is, it should choose the last CS line out of the three lines with the same order number. Can Tableau does it? Thank you