Load multiple workbooks with the same columns

[hucand]

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] 

[kaushiknsolanki · Accepted solution]

Try this,

LOAD

col1,

col2,

col3

FROM [lib://DataFiles/*.xlsx] 

[hucand]

I get this error:

A potentially dangerous Request.Path value was detected from the client

[kaushiknsolanki]

This doesnt seems to be a Qlik Error. Can you share the screenshot of the error.