topic Re: Inline and count in QlikView

Inline and count

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

I have an inline table.

Values:

Load * inline

[

];

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?

Re: Inline and count

PrashantSangle — Thu, 13 Jul 2017 12:44:10 GMT

provide more details

Regards

Re: Inline and count

arvind_patil — Thu, 13 Jul 2017 12:58:18 GMT

Hi David,

Instead of inline, You may use Filename function.

Load *, filename() as Filename

From *.txt (txt);

Thanks,

Arvind Patil

Re: Inline and count

jmvilaplanap — Thu, 13 Jul 2017 13:09:15 GMT

Could you give us a better example please?

Regards

Re: Inline and count

Kushal_Chawda — Thu, 13 Jul 2017 13:12:08 GMT

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;