Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

X=30

DO UNTIL X=315

IF FileSize (PathX)>0 THEN

  Logins:

   LOAD employee,

   name,

   last name,

   login,

   logout

  FROM

  $(PathX)

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

ELSE

  SET xls_exists=0;

END IF

X=X+1

LOOP

 

 

5 Replies
Miguel_Angel_Baeyens

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

Not applicable
Author

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

Not applicable
Author

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 

Miguel_Angel_Baeyens

Hi Tomi,

Did you try using instead

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

Hope that helps.

Miguel

Not applicable
Author

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

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