Discussion board where members can get started with QlikView.
I have an inline table.
Load * inline
I have a number of unrelated excel files that would match with the inline table.
So for example
Not that they are related, but the I want to match the line of text associated with tableA with inline A and tableB with inline B.
What I could do would be to create separate inline tables and left join?
But surely there must be a simpler way without creating all these tables?
provide more details
Instead of inline, You may use Filename function.
Load *, filename() as Filename
From *.txt (txt);
Could you give us a better example please?
do like below
SET vFilePath ='D:\QlikView\Excel';
LOAD * inline [
for each vFile in filelist ($(vFilePath) &'\'&'$(vFileExtension)')
filebasename() as FileName
(fix, codepage is 1252);
drop field Temp;