If I am creating two tables in qlikview by loading fields from the same qvd table. Those two tables seem to be correlated but I have no idea why. They dont have a common field name. Is it because they are subset of the same qvd table?
Hi Diwaskarki, I think if the columns of these 2 tables are totally different, these 2 tables won't be correlated. For example, if you won't set any table name in script, and there is a qvd called Country. there are some columns in it, like A,B,C,D,E. And in script:
Load A,B from Country.qvd(qvd); Load C,D from Country.qvd(qvd);
Then Reload, I think you will get 2 tables(Country, Country-1) and no correlation. Aiolos Zhao