Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
danaleota
New Contributor II

Trying to give an alias but getting field not found error

When I try to add an alias to my second table field name "Location" to Site I receive "Field 'Location' not found" .  Also when loading my tables into data editor Qlik  is referring to two different tables by the same name. 

 

LOAD
    "Date",
    Site,
    Supervisor,
    Segment,
    ANS
FROM [lib://AttachedFiles/MayDaily_MTD.xlsx]
(ooxml, embedded labels, table is Sheet1);

LOAD
    DateCompleted,
    CallDate,
    AddedBy,
    AgentName,
    Supervisor,
    [Location] as Site,
    CallType,
    FormType,
    CoachingDetails,
    CoachingErrorType,
    CallInfoType,
    CreditUnionName,
    Segment,
    CallId
FROM [lib://AttachedFiles/Feedback Form May 31.xlsx]
(ooxml, embedded labels, table is Sheet1);

2 Replies
mwoolf
Honored Contributor II

Re: Trying to give an alias but getting field not found error

For your second load, put: noconcatenate load

Community Manager
Community Manager

Re: Trying to give an alias but getting field not found error

@mwoolf  Are you using QlikView or Sense?  I would like to move this into the correct product forum. Thank you.

Sue Macaluso