Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

QlikView read few information

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

14 Replies
danielrozental
Master II
Master II

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.

pgalvezt
Specialist
Specialist
Author

Yes Im sure

pgalvezt
Specialist
Specialist
Author

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.

danielrozental
Master II
Master II

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?

pgalvezt
Specialist
Specialist
Author

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