2 Replies Latest reply: Jul 13, 2016 5:33 PM by Robert Winkel RSS

    LOAD ERRORS

    Robert Winkel

      Why when I load this not all the field load into the Data tables?

       

      hrxs:

      LOAD *;
      SQL SELECT
      HRxs.[PhrNPI] as [FWUserID],                                    ***DOSE NOT DISPLAY IN DATA TABLE****
        HRxs.eRxMsgID,
      HRxs.FacID,
      HRxs.InitReview as DateRange                              ***DOSE NOT DISPLAY IN DATA TABLE****

      FROM Rx.dbo.HRxs

       

      Or if I change this  HRxs.InitReview as DateRange, to just  HRxs.InitReview, it will not load?

       

      Or if I just do this on a field it wont load?   //  HRxs.InitReview as DateRange,