Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Visualization and Usability

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this solution

Ivan_Bozov
Luminary
Luminary

How about this:

Table:
LOAD
	ID,
	Name,
	Age,
	Gender
FROM [lib://Desktop/TESTING.xlsx]
(ooxml, embedded labels, table is Sheet1);


FOR EACH SheetName IN 'Sheet2', 'Sheet3'
LOAD
	A AS ID,
	B AS Name,
	C AS Age,
	D AS Gender
FROM [lib://Desktop/TESTING.xlsx]
(ooxml, no labels, table is $(SheetName));
NEXT;
vizmind.eu

View solution in original post

Who Me Too'd this solution