Trying to give an alias but getting field not found error

[danaleota]

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

[m_woolf]

For your second load, put: noconcatenate load

[Sue_Macaluso]

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