Inline and count

[bobbydave]

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?

[PrashantSangle]

provide more details

Regards

[arvind_patil]

Hi David,

Instead of inline, You may use  Filename function.

Load *, filename() as Filename

From *.txt (txt);

Thanks,

Arvind Patil

[jmvilaplanap]

Could you give us a better example please?

Regards

[Kushal_Chawda]

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;