6 Replies Latest reply: May 29, 2014 3:15 PM by Eduardo Sommer RSS

    Select first value only

    Matt Maino

      In my script I have defined a table that loads in fields called account_nbr and production_date. I am limiting these field values that are loaded in by only loading in those where another field equals a certain value. This is what it looks like:

       

      Table2:

      LOAD

      account_nbr

      production_date

      Resident Table1

      where fieldName = 1;

       

      My goal is to only load the first row for each account_nbr where fieldName = 1. Is this possible? Right now I am getting multiple rows loaded for each account_nbr since fieldName = 1 for more than one production_date. To put it more simply, I am only interested in loading the account_nbr and production_date values where the fieldName = 1 for the first time, and nothing after that. Thanks for the help.