data is not associated in single table

Wed, 04 Aug 2010 18:33:47 GMT

Need help, ASAP, please !!!!

Weird stuff. I load data into 4 .qvd files. After that, in a separate .qvw file, I load them using this code:

for each QVDFile in 'SLOB_BASE_MAY_LD','SLOB_BASE_JUN_LD','SLOB_RPRT_MAY_LD','SLOB_RPRT_JUN_LD'
let ArchiveFile = 'C:\Documents and Settings\sbenke\Desktop\SLOB\$(QVDFile).qvd';
BigFileTmp:
load *
from '$(ArchiveFile)' (qvd);
next QVDFile;

When I load in "Table view", I see only one table (BigFileTmp) after the load. But, the data is not associated. Example, I have column called State and column called Region. State "CA" has two Regions: LA and Northern CA. When I click on "CA" in State, I still see ALL Regions in "white" in Region column. It is the same for ALL fields.

I do not know what is going wrong. What I am doing wrong?

Please advise.

topic data is not associated in single table in QlikView

data is not associated in single table