Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

LOAD ERRORS

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,

1 Solution

Accepted Solutions
bellamae
Valued Contributor

Re: LOAD ERRORS

When you say won't load do you mean it errors or does it just not populate any data?

2 Replies
bellamae
Valued Contributor

Re: LOAD ERRORS

When you say won't load do you mean it errors or does it just not populate any data?

Not applicable

Re: LOAD ERRORS

Yes but I got that figured out now   Can't have the same name in multiple tables.

Now I an working on an inner join.

Community Browser