Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Left Join causes columns to vanish

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

5 Replies
Gabriel
Valued Contributor II

Re: Left Join causes columns to vanish

Hi,

Please share qvw file.

Re: Left Join causes columns to vanish

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

ramoncova06
Valued Contributor III

Re: Left Join causes columns to vanish

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

Not applicable

Re: Left Join causes columns to vanish

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.

Not applicable

Re: Left Join causes columns to vanish

My mistake,

"LEFT JOIN TableX:" is deprecated,

if I use

"LEFT JOIN ( TableX )" it works.

Community Browser