DSXchange

Hi all,
HI have a job in which there are two source datasets and i m trying to join these datasets based on three columns(mkt code,sale date and mob_no) and join conditionm is full outer. But when i am running a job it get abored and gives an error message
main_program: Fatal Error: Destination "leftRec.leftRec_MKT_CODE" is already bound.

Can anyone help me to resolve this issue?

Thanks

My guess - you have identically-named columns on both inputs and the result of the join - you have not provided separate output columns into which to map the left and right input columns.

To add to what Ray has already said, another possibility is that you have runtime column propagation turned on and don't directly "see" the duplicated column name becuase it has been passed in from a previous stage.