topic Re: Left Join causes columns to vanish in QlikView

Left Join causes columns to vanish

Thu, 21 May 2015 13:38:24 GMT

Hi,

I've got a problem I can't figure out,

I have two tables I try to left join but two columns vanish.

LEFT JOIN BKN_REF2:

LOAD

MONATS_DATUM

, RBKn

, oBK

Resident tabRBK;

DROP TABLE tabRBK;

After that it looks like

in tabRBK the values of 'RBKn' and 'oBK' match, some of the value pairs for 'oBK' and 'MONATS_DATUM' are in both tables but the columns 'RBKn' and 'oBK' vanish.

Does anybody have an idea what I should try or look for?

Regards,

Hutsch

Message was edited by: Robert Hutschenreuter Attached qvw Because of privacy reasons I can't attach the qvd files so I added some inline loads. No the Problem occurs between lines 50 and 68, too

Re: Left Join causes columns to vanish

Gabriel — Thu, 21 May 2015 15:25:52 GMT

Hi,

Please share qvw file.

Re: Left Join causes columns to vanish

Anonymous — Thu, 21 May 2015 15:32:48 GMT

I always prefer a Mapping Load and an ApplyMap() , instead of a Left join. Could you do it that way instead ?

Re: Left Join causes columns to vanish

ramoncova06 — Thu, 21 May 2015 15:34:05 GMT

please add the script before the left join, with the current info is hard to tell what could be the problem

Re: Left Join causes columns to vanish

Fri, 22 May 2015 08:35:03 GMT

I don't think it would work,

the REF table is a hierarchy where objects might have multiple parents,

e.g. A is child of B and C, B gets 30% and C 70%,

if D is the child of A, A gets 100% of D (but B gets 30% of D)

these relations can change over time and I need to know which object at what times belongs to which tree.

Re: Left Join causes columns to vanish

Thu, 28 Jul 2016 07:57:04 GMT

My mistake,

"LEFT JOIN TableX:" is deprecated,

if I use

"LEFT JOIN ( TableX )" it works.