4 Replies Latest reply on Apr 30, 2018 11:43 PM by David Gabra

    Comparing 2 lists

    David Gabra

      Hi

      I have to do the following in tableau due to the size of the data.

      I have a list of  official codes that are classified as Non PO invoices

      I would like  to know if there are Non PO invoices that contain other codes other than the official codes.

      Thank you

      David.

       

      Table A

       

      Invoice #CategoryAccountCode
      22Non PO3000
      33Non PO4000
      44Non PO5000This should not be PO

       

      Table B:

       

      Non PO Codes
      3000
      4000

       

      Please can you help me create the calculated field.

      I started to create the .twbx but got stuck - I know its really simple - just can't do it

       

      Thanks

      David.