QlikView read few information

[pgalvezt]

Hello, Im trying to left automate my model. So I have this:

or each vFile in filelist ('E:\Modelos\Nueva carpeta\*.dbf')

//Let vTableName = subfield(mid('$(File)', index('$(File)', '\',-1) +1), '.dbf', 1);

ODBC CONNECT TO [DBF PROJECT];

TableContent:

SQL SELECT *

FROM `$(vTableName)`

Where estado =1 And deudat <> 0;

next vFile

But first: When I load separately the dbf files QlikView read 1 million 900000 600000 and so on

When I load with this script QlikView read 55000 131000 and so on.

Second: qlikView read just one file always appears in the load windows the same name.

Thanks

[danielrozental]

You're reading from the vTableName file but the "Let vTableName" line is commented out so it's not cycling through available files.

[pgalvezt]

When I discomment appears a load Error See the attached pls.

[pgalvezt]

Any Help?

[danielrozental]

You should really go back to the tutorial or take a development class.

This

Let vTableName = subfield(mid('$(File)', index('$(File)', '\',-1) +1), '.dbf', 1);

Should be

Let vTableName = subfield(mid('$(vFile)', index('$(vFile)', '\',-1) +1), '.dbf', 1);

[pgalvezt]

Thank you for your reply. Works now but QlikView still read a few data. And QlikView to stop the execution.

[pgalvezt]

Any Help?

[pgalvezt]

Why QlikView is reading FROM excel4.xls??

Thanks!

[danielrozental]

Because you were using the variable "File" instead of "vFile". Variable File probably has an old value that was never updated.

[pgalvezt]

For any reason QlikView Read less data i don't know why should be working.