5 Replies Latest reply: Feb 2, 2016 9:25 AM by Chris Porthouse RSS

    Extracting records based on 3 columns?

    Rob Hill

      I have a daily SAP file of equipment records that is approximately 60k rows by 27 columns.  Each row represents an individual equipment record and 3 of the columns contain plant information.  I have no trouble creating a model and getting all of the data to a table but what I am missing is how to exclude the data I do not need.  The 3 columns with plant info each contain a specific plant code such as 004Y.  If all 3 plant codes are the same then I don't need to review that record but if the 3 are not equal then I need to review that row.  Appreciate any suggestions offered.