Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Left join statment

Hi,

Im having problem with joining tables together, im trying to add the values from C_OUTBOUND_DELIVERY_BOX.QTY_TO_DELIVER

  ,C_OUTBOUND_DELIVERY_BOX.CONTRACT based on Key_BOX. I have to problems after the left join statment.

1. Theres added to new columns, but one has no columnname and the second has the name: C_OUTBOUND_DELIVERY_BOX-1

2. the values of the new columns are only "-"

Tmp:

load

          Key_BOX

          ,RETWHO_BOX_IN_STOCK_OVERVIEW_Copy.QTY_IN_STOCK

          ,RETWHO_BOX_IN_STOCK_OVERVIEW_Copy.CONTRACT

          ,1 as RetwhoQtyInStockDC

resident RETWHO_BOX_IN_STOCK_OVERVIEW_Copy;

left join (Tmp)

load

          Key_BOX

          ,C_OUTBOUND_DELIVERY_BOX.QTY_TO_DELIVER

          ,C_OUTBOUND_DELIVERY_BOX.CONTRACT

resident C_OUTBOUND_DELIVERY_BOX;

thanks

1 Solution

Accepted Solutions
Not applicable
Author

thanks for your answers, but i fixed it with: unQualify *;

View solution in original post

4 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Hello,

Your code is correct. Can you plz attach sample file with data.

er_mohit
Master II
Master II

try concatenate function replace of join

hope it helps

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Please post sample data file.

Not applicable
Author

thanks for your answers, but i fixed it with: unQualify *;