topic Re: Left join statment in QlikView

Left join statment

Fri, 04 Jan 2013 08:32:43 GMT

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

jagannalla — Fri, 04 Jan 2013 09:23:27 GMT

Hello,

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

er_mohit — Fri, 04 Jan 2013 09:35:42 GMT

try concatenate function replace of join

hope it helps

Gabriel — Fri, 04 Jan 2013 11:13:58 GMT

Hi,

Please post sample data file.

Fri, 04 Jan 2013 14:46:53 GMT

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