LOAD ERRORS

[#1]

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,

[Anonymous · Accepted solution]

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

[#3]

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.