topic Re: Due To left join Qlikview Server hang... in QlikView

Due To left join Qlikview Server hang...

er_mohit — Fri, 30 Aug 2013 09:49:37 GMT

hiiiiii community

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

Re: Due To left join Qlikview Server hang...

vikasmahajan — Fri, 30 Aug 2013 10:14:51 GMT

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

Re: Due To left join Qlikview Server hang...

tresB — Fri, 30 Aug 2013 10:21:32 GMT

Hello Mohit,

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.

Re: Due To left join Qlikview Server hang...

marcus_malinow — Fri, 30 Aug 2013 10:25:27 GMT

I'd also suggest checking that you don't have any NULLS in the field you're joining. Easy way to get a nice big Cartesian join!

Re: Due To left join Qlikview Server hang...

Fri, 30 Aug 2013 10:54:30 GMT

Hi,

you can try to use applymap instead of left join.

For example view this link http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/