Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Inline and count

I have an inline table.

Values:

Load * inline

[

     A,

     B,

     C,

     D

];

I have a number of unrelated excel files that would match with the inline table.

So for example

TableA:

Load *,

       DateOfFile

From FileA.xlsx

TableB:

Load *,

       DateOfFile

From FileB.xlsx

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?

4 Replies
Highlighted

Re: Inline and count

provide more details

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Partner
Partner

Re: Inline and count

Hi David,



Instead of inline, You may use  Filename function.


Load *, filename() as Filename

From *.txt (txt);

Thanks,

Arvind Patil

Highlighted
Specialist
Specialist

Re: Inline and count

Could you give us a better example please?

Regards

Highlighted
MVP
MVP

Re: Inline and count

do like below

SET vFileExtension='*.xlsx';

SET vFilePath ='D:\QlikView\Excel';

Data:

LOAD * inline [

Temp ];

for each vFile in filelist ($(vFilePath) &'\'&'$(vFileExtension)')

Concatenate(Data)

LOAD *,

            filebasename() as FileName

FROM

[$(vFile )]

(fix, codepage is 1252);

next vFile


drop field Temp;