topic Re: var script load in QlikView

var script load

Thu, 20 Apr 2017 12:25:34 GMT

hi all,

I need help. I have to load an excel file every day, but only current day file. So, i try to use a var in script... but doesn't work.

LOAD * FROM [$(Ruta)] (ooxml, embedded labels, header is 3 lines, table is SN);

Var definition:

'D:\QV\App\data(' & date(today(),'YYYY-MM-DD')& ')*'

Please could you help??

Re: var script load

kaushiknsolanki — Thu, 20 Apr 2017 12:34:04 GMT

Hi try this way in script.

Let vDate = Date(Today(),'YYYY-MM-DD')&'.xls';

Load * from 'D:\QV\App\data'&$(vDate)

(ooxml, embedded labels, header is 3 lines, table is SN);

;

Regards,

Kaushik Solanki

Re: var script load

sunny_talwar — Thu, 20 Apr 2017 12:34:13 GMT

Are you using SET or LET? Try with LET

LET Ruta = 'D:\QV\App\data(' & date(today(),'YYYY-MM-DD')& ')*.xlsx';

LOAD *

FROM [$(Ruta)]

(ooxml, embedded labels, header is 3 lines, table is SN);

Re: var script load

Thu, 20 Apr 2017 14:19:10 GMT

Thanks Sunny

Re: var script load

sunny_talwar — Thu, 20 Apr 2017 14:23:37 GMT

Did you want to thank Kaushik? Seems like his solution worked for you

Please mark his response as correct to close the thread down.

Best,

Sunny

Re: var script load

Peter_Cammaert — Thu, 20 Apr 2017 14:31:10 GMT

Actually the LET is optional. A clean variable assignment a = b; also expects b to be an expression (or a quoted string or whatever).

The SET on the other hand isn't optional.

But you're probably right. The variable overview shows that Ruta contains a stringized expression, not an evaluated expression. So aside from replacing a SET by a LET, IIRC it could also be fixed by doing something like:

LOAD * FROM [$(=Ruta)] (options);

no?

Re: var script load

kaushiknsolanki — Fri, 21 Apr 2017 05:09:36 GMT

Thanks stalwar1‌.

What is important is Francisco got the solution.

Regards,

Kaushik Solanki