Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please share qvw file.
I always prefer a Mapping Load and an ApplyMap() , instead of a Left join. Could you do it that way instead ?
please add the script before the left join, with the current info is hard to tell what could be the problem
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.
My mistake,
"LEFT JOIN TableX:" is deprecated,
if I use
"LEFT JOIN ( TableX )" it works.