Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted
Master II
Master II

For your second load, put: noconcatenate load

Highlighted
Community Manager
Community Manager

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

Sue Macaluso