Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

invalid column name

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';

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: invalid column name

what about generating the same SQL statement again?

4 Replies
MVP & Luminary
MVP & Luminary

Re: invalid column name

I can only assume that these fields used to be present in the table at the time of this script creation, however the fields are not there anymore.

Have you tried generating the same SQL statement again using the wizard? You should receive only the fields that are currently there...

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming to Austin, TX in October!

Not applicable

Re: invalid column name

it always does it on the last one.  If I delete it it just goes up to the next one

MVP & Luminary
MVP & Luminary

Re: invalid column name

what about generating the same SQL statement again?

praveenavelagap
Contributor III

Re: invalid column name

Replace AND TransType <> 'Q''R'  with 


AND not match ( TransaType,'Q','R')