topic HELP !!! Why the script doesn't Works? in QlikView

HELP !!! Why the script doesn't Works?

Tue, 29 Nov 2011 15:21:31 GMT

X=30

DO UNTIL X=315

IF FileSize (PathX)>0 THEN

Logins:

LOAD employee,

name,

last name,

logout

FROM

$(PathX)

(biff, embedded labels, table is Phaze1$);

ELSE

SET xls_exists=0;

END IF

X=X+1

LOOP

HELP !!! Why the script doesn't Works?

Miguel_Angel_Baeyens — Tue, 29 Nov 2011 15:31:22 GMT

Hi,

Code seems to be fine. What does the PathX store? Is that a variable? What error do you get? A simple code with AUTOGENERATE instead of FROM works fine (loads 285 times).

Regards.

Miguel

Re: HELP !!! Why the script doesn't Works?

Tue, 29 Nov 2011 15:52:38 GMT

Thank you for your answering.

'PathX' was defined before the code, and it's a variable:

PathX = 'U:\Reports\ & YEAR(Today(1)-X) & '\' & MONTH(Today(1)-X)..

I don't receive any error, all of data that suppose to be loaded with the code, doesn't appears. All fields are empty.

Do you have any idea?

Best Regards,

Tomi

HELP !!! Why the script doesn't Works?

Tue, 29 Nov 2011 15:52:51 GMT

Thank you for your answering.

'PathX' was defined before the code, and it's a variable:

PathX = 'U:\Reports\ & YEAR(Today(1)-X) & '\' & MONTH(Today(1)-X)..

I don't receive any error, all of data that suppose to be loaded with the code, doesn't appears. All fields are empty.

Do you have any idea?

Best Regards,

Tomi

Re: HELP !!! Why the script doesn't Works?

Miguel_Angel_Baeyens — Tue, 29 Nov 2011 16:56:01 GMT

Hi Tomi,

Did you try using instead

IF FileSize('$(PathX)') > 0 THEN

Hope that helps.

Miguel

HELP !!! Why the script doesn't Works?

Wed, 30 Nov 2011 08:08:38 GMT

Thank you very mach Miguel, your answer was Helpful..

It's gived me a hint what should i do..