13 Replies Latest reply: Feb 17, 2017 2:00 PM by fredrik olsson RSS

    Table field relation in load statement

    fredrik olsson

      Hi,

       

      I'm trying to use a related field in the where clause of my load statement, but if fails.

       

      LOAD

          Booking AS BookingId,

          Destination AS BookingDestination;

       

      LOAD

          IATA as BookingDestination,

          ContinentCode as BookingContinentCode;

       

      The following WHERE clause later in the load statement fails becuase "BookingContinentCode"  is unkown:

      WHERE BookingId = 2134 AND BookingContinentCode = 'EU';

       

      Any help are appreciated!