topic Re: Data file Name into QVD in QlikView

Data file Name into QVD

Tue, 10 Feb 2015 11:31:54 GMT

Hey,

Can I generate a QVD file that contains FileName of data files i am loading. And without using macro?

Re: Data file Name into QVD

sunny_talwar — Tue, 10 Feb 2015 11:36:30 GMT

I usually do something like this in the load script.

Table:

LOAD yourFields,

'SourceFileName' as [Source File Name]

FROM

SourceFile....

Store Table into ....

This would add the SourceFileName to all the data and can then be used to filter in your original application.

Not sure if this is what you wanted to do, but I hope it helps.

Best,

Re: Data file Name into QVD

datanibbler — Tue, 10 Feb 2015 11:46:27 GMT

Hi @sunindia,

that is completely correct.

I would just like to add a common pitfall - that I, for my part, stumbled into a few times:

Just using, like "LOAD ... FROM;" without any further details won't work.

You have to specify what type of file you are loading. The easiest way to get these is to load something from that file (using the wizard, don't worry about details, just open the wizard and click on the file, make sure QlikView recognizes the file_type and then click "Finish"), delete the "sheet is" part, that is not needed for the filename, and then build the LOAD like sunindia proposed.

Best regards,

DataNibbler

Re: Data file Name into QVD

Tue, 10 Feb 2015 11:55:56 GMT

I have hundred of files in folder and I don't wish to write file names

Re: Data file Name into QVD

marcus_sommer — Tue, 10 Feb 2015 13:26:50 GMT

For this you could use file-functions like filename() - there are many more:

table:

Load *, filebasename() as Source From xyz;

- Marcus

Re: Data file Name into QVD

Wed, 11 Feb 2015 04:23:20 GMT

I used distinct without loading other fields and I got one row for each file