topic Re: Store QVD file, using field name in QlikView

Store QVD file, using field name

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

Can anyone help with this please, I am really struggling.

I have a typical load script as below, that will only ever contain one row of data:

table:

LOAD 1,2,3,4,HOSTNAME

The hostname is a file path, example c:\file.csv or \\pcname\c$\file.csv

I am then trying to store the file,

store [table] into [$HOSTNAME] (txt, delimiter is '|');

Whenever the script is run, it should dynamically store the file, according to the folder/file location in the HOSTNAME field.

Can anyone help please, have trawled the forums for hours searching for an example that works.

Thanks

Re: Store QVD file, using field name

agomes1971 — Thu, 02 Aug 2018 16:04:57 GMT

Hi,

try this:

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

STORE $(vTableName) INTO $(vTableName).qvd (qvd);

NEXT vCount

HTH

André Gomes

Re: Store QVD file, using field name

mattbrain — Thu, 02 Aug 2018 16:12:08 GMT

Thanks, how would I work that to my example, when I run this it calls the file "table" as thats the table name, but I want the file name to be the data contained within HOSTNAME table?

Really appreciate your help

Re: Store QVD file, using field name

agomes1971 — Thu, 02 Aug 2018 16:22:21 GMT

OK,

maybe something like this:

Table:

LOAD 1,2,3,4,[HOSTNAME]

from yoursource;

LET vHostName = peek([HOSTNAME],0);

YourData:

LOAD * from yoursource;

STORE YourData into vHostName.qvd (qvd);

HTH

André Gomes