Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Left join statment

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

4 Replies
jagannalla
Valued Contributor III

Re: Left join statment

Hello,

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

er_mohit
Honored Contributor II

Re: Left join statment

try concatenate function replace of join

hope it helps

Gabriel
Valued Contributor III

Re: Left join statment

Hi,

Please post sample data file.

Not applicable

Re: Left join statment

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

Community Browser