Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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