topic Re: QlikView read few information in QlikView

QlikView read few information

pgalvezt — Tue, 11 Sep 2012 17:07:18 GMT

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

Re: QlikView read few information

danielrozental — Tue, 11 Sep 2012 17:21:34 GMT

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

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 17:26:16 GMT

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

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 17:39:48 GMT

Any Help?

Re: QlikView read few information

danielrozental — Tue, 11 Sep 2012 17:46:38 GMT

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);

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 17:50:40 GMT

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

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 18:08:32 GMT

Any Help?

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 18:19:44 GMT

Why QlikView is reading FROM excel4.xls??

Thanks!

Re: QlikView read few information

danielrozental — Tue, 11 Sep 2012 18:46:15 GMT

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

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 18:52:26 GMT

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

Re: QlikView read few information

danielrozental — Tue, 11 Sep 2012 18:59:15 GMT

Are you sure QlikView is reading all the same files?

You should really get in contact with a QlikView Partner and have them help you build your application.

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 19:02:23 GMT

Yes Im sure

Re: QlikView read few information

pgalvezt — Tue, 11 Sep 2012 19:10:42 GMT

My App is ready I just need to automate. I would like to have help for QlikView Partner but I don't have these help.

Re: QlikView read few information

danielrozental — Tue, 11 Sep 2012 19:15:53 GMT

Can you post the log generated by the application when being run through the qlikview server and the log you get when you run it in qv desktop?

Re: QlikView read few information

pgalvezt — Wed, 12 Sep 2012 13:30:05 GMT

The Problem was a DLL Visual Fox Pro. Now the data is being correctly By QlikView.