Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
For your second load, put: noconcatenate load
@m_woolf Are you using QlikView or Sense? I would like to move this into the correct product forum. Thank you.