4 Replies Latest reply: Sep 16, 2016 6:16 PM by Praveena Velagapudi RSS

    invalid column name

    Robert Winkel

      I keep getting an invalid column name as pic one shows.

      If I \\ it tells me that that's a bad column field.

      Any clues?

      I copied the files from a working set but it keeps doing this.

      LOAD *;
      SQL SELECT FacID,
      eRxMsgID,
          RxNo,
          DispenseDt,
          PatID,
          TransType,
          PharmID,
          PhrNPI,
          PhName,
          NDC,
          DrugLabelName,
          MOP,
          MOP2,
          PriceCd,
          TtlPrice,
          Payor1PaidAmt,
          Payor2PaidAmt,
          PatientPayAmt,
          Lables,
          NewRx,
          IVType,
          InvCost,
          EnteredByNPI,
          Entered,
          PackBy,
          Packed,
          CheckedBy,
          Checked,
          InitReview,
          PlacedInToteBy,
          PlacedInTote,
          TherapeuticInterchange,
          DelivID,
          DelivDate,
          LabelPrintedBy
      //     LabelPrintedOn
         
      FROM FwArchive.dbo.ECSHistory

      Where FacId <> 'FORMS'
      AND FacId <> 'MSTR'
      AND FacId <> 'RETAIL'
      AND FacId <> 'SAMPLE'
      AND FacId <> 'TEST'
      AND FacId <> 'TEST#2'
      AND FacId <> 'TEST2'
      AND FacId <> 'TEST3'
      AND FacId <> 'TRLK'
      AND FacId <> 'stag'
      AND TransType <> 'Q''R'
      AND Entered >= '2015-12-01 00:00:00';