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);