topic Connection Advice in QlikView

Connection Advice

pgalvezt — Thu, 30 Aug 2012 21:14:47 GMT

Time ago I read a post about how connect many bases with same tables. In that case it created like a Link tables that Had the follows syntaxis:

OLEDB CONNECT TO [Provider=VFPOLEDB.1;......................

LOAD*, 'Site1' as Source;
LOAD

FieldA

FieldB

FieldC

SQL SELECT *

FROM `A_20`

Where FieldA =1 And FieldB <> 5;

LOAD*, 'Site2' as Source;
LOAD

FieldA

FieldB

FieldC

SQL SELECT *

FROM `A_20`

Where FieldA =1 And FieldB <> 5;

//And so on

Is the best way?

I have many folders (its like have many excels files from differents folders and with the same tables)

Example qvw. Goes January 2012 February 2012. January 2012 other base.

Thanks