Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
thanks for your answers, but i fixed it with: unQualify *;
Hello,
Your code is correct. Can you plz attach sample file with data.
try concatenate function replace of join
hope it helps
Hi,
Please post sample data file.
thanks for your answers, but i fixed it with: unQualify *;