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?
