Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I load multiple workbooks with the same columns?
I'm trying to do something like:
LOAD
col1,
col2,
col3
FROM [lib://DataFiles/sheet1.xlsx, lib://DataFiles/sheet2.xlsx]
Try this,
LOAD
col1,
col2,
col3
FROM [lib://DataFiles/*.xlsx]
Try this,
LOAD
col1,
col2,
col3
FROM [lib://DataFiles/*.xlsx]
I get this error:
A potentially dangerous Request.Path value was detected from the client
This doesnt seems to be a Qlik Error. Can you share the screenshot of the error.