i m facing a problem in qlikview .....................
i have two tables like
tableA:
load id,
name,
docno
from datasource;
in this table there are 550000 records
the 2nd table is
tableB:
load id,
[material group],
devision_code,
MatId
from datasource;
in this table there are 30000 records.
what i want all the fields data of tableB in tableA,
for this i use left join between both tables
and then store tableA into finaltable.qvd;
drop table tableA;
when i reload it then it feches the recor from tableA and tableB
but due to left join it hangs the qlikview server and i use left keep then it doesn't join the fields of tableB into tableA it shows two separate table
how could i store both tables into a single common table. its a simple issue but don't know why its not working my other applications works like a charm
your help will be appreciated i get rid off this problem
Kindly paste your scripts for answers it is hard to say any thing with out it , Please check same query runs in sql and take how much time also you need to check on clause common field between Tab A & Tab B other wise it should works with any issue
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
Make sure that your 'id' field contains unique values at least in one of the tables. If that is ensured, there should not be an issue joining them.
As you might know that the repeated values in both tables for key field make the joining produce multipled no of records and results into wrong data and could hang if the multipled no becomes a huge one.
