topic Variables as file and table paths in load script in QlikView

Variables as file and table paths in load script

Tue, 22 Oct 2013 15:15:53 GMT

Hi,

I'd like to assign table names and source files to variables and use it throughout my load script. Like so..

SET vSourceFileName0 = 'source_file_1.csv';
SET vSourceFilePath0 = 'C:\my files\Sept2013\';
SET vSourceTableName0 = 'MS_SQL_table_1';

MySQLTable:
SQL SELECT * FROM vSourceTableName0;

MyFileSource:
LOAD *
FROM
vSourceFilePath0 & vSourceFileName0
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, no eof);

Doesn't seem to be working...

Re: Variables as file and table paths in load script

Tue, 22 Oct 2013 15:18:19 GMT

Hi,

Try to retrieve the variable value with $(vSourceFileName0)

Re: Variables as file and table paths in load script

Aurelien_Martinez — Tue, 22 Oct 2013 15:19:43 GMT

Hi,

SET vSourceFileName0 = 'source_file_1.csv';

SET vSourceFilePath0 = 'C:\my files\Sept2013\';

SET vSourceTableName0 = 'MS_SQL_table_1';

MySQLTable:

SQL SELECT * FROM $(vSourceTableName0);

MyFileSource:

LOAD *

FROM

$(vSourceFilePath0)$(vSourceFileName0)

(txt, codepage is 1252, embedded labels, delimiter is ',', msq, no eof);

Regards,

Aurélien