5 Replies Latest reply on Feb 7, 2017 10:48 PM by Mahfooj Khan

    Tableau Lookup

    Chadd Dumagas

      Hi Everyone,

       

      I'm new to Lookup in Tableau. So basically i want to do like a max if in excel then

       

      My data goes something like

      Content ID       Version      Some fields          Some Fields          Some Fields          Calculated Field

      --------------------------------------------------------------------------------------------------------------------------------

      22222                    1                                                                                                                   0

      --------------------------------------------------------------------------------------------------------------------------------

      22222                    2                                                                                                                   1

      --------------------------------------------------------------------------------------------------------------------------------

      33333                    1                                                                                                                   1              

      --------------------------------------------------------------------------------------------------------------------------------                                                                                            

      44444                    1                                                                                                                   0

      --------------------------------------------------------------------------------------------------------------------------------

      44444                    2                                                                                                                   0

      --------------------------------------------------------------------------------------------------------------------------------

      44444                    3                                                                                                                   1

      --------------------------------------------------------------------------------------------------------------------------------

      55555                    1                                                                                                                   0

      --------------------------------------------------------------------------------------------------------------------------------

      55555                    2                                                                                                                   1

      --------------------------------------------------------------------------------------------------------------------------------

      66666                    1                                                                                                                   0

      --------------------------------------------------------------------------------------------------------------------------------

      66666                    2                                                                                                                   0

      --------------------------------------------------------------------------------------------------------------------------------

      66666                    3                                                                                                                   0

      --------------------------------------------------------------------------------------------------------------------------------

      66666                    4                                                                                                                   1

      --------------------------------------------------------------------------------------------------------------------------------

      77777                    1                                                                                                                   1

       

      Take note that the Version is not necessarily arranged as 1,2,3 nor the Content ID, they could be messily sorted out in all the rows.

       

      Output of the Calculated Field

      The calculated field shows only 1 for the most updated version of the Content ID

      So its like get the max version of that id, then compare to the version of the current row, if true 1 otherwise 0.

       

       

      Does anyone know how to deal with this?