Duplicate values due to Item Code

[Anonymous]

Dear All,

I getting stuck here with the item code .

I getting duplicate values against item code when I remove Item code from chart then i am come to near my output but here is also I am missing my Shipment No. SHGO316/000207

Here I am missing Shipment No. SHGO316/000207

Pfa qvw attachment with expected output.

Can anyone help me out.

Thanks

[tresesco]

Like this?

[Anonymous]

But when I add Item code here then why values getting duplicate.

But i need to show quantity in Expression

Any Suggestion ???

[tresesco]

I don't see Item_Code in your expected output. Please share your exact expected output.

[sunny_talwar]

I think the key between the two tables is not granular enough to give you Item_Code level Quantity.... You are joining the two tables on Document No_ and whereas it seems that you want to join on Document No_ and Item_Code. Is there Item information in Shipment table? It seems No_ include the same information as Item_Code... try this

Shipment:

LOAD [Document No_] as ShipmentNo,

    [Sell-to Customer No_],

    Type,

   No_ as Item_Code,

    [Location Code],

    [Shipment Date],

    Description,

    Quantity,

    [Unit Price],

    [Unit Cost (LCY)],

    [Shortcut Dimension 1 Code],

    [Shortcut Dimension 2 Code],

    [Order No_] as DocNum,

    [Order No_] ,

    [Order Line No_],

    [Bill-to Customer No_],

    [Gen_ Bus_ Posting Group],

    [Gen_ Prod_ Posting Group],

    [Unit Cost],

    [Posting Date],

    [Planned Delivery Date],

    [Planned Shipment Date],

    [Order Date]

FROM

(qvd)

where  Quantity  <> 0;

and may be you want to further link them on the Location Code also....

Note: You will get synthetic key which can be avoided by created a concatenated key using Document No_ and No_ field from Shipment table and similarly Document No_ and Item_Code from SalesLine table

[Anonymous]

PFA...

[Anonymous]

stalwar1 , swuehl , tresesco / All,

Any update on this?

[sunny_talwar]

Did you look at what I proposed?

[Anonymous]

Hi Sunny ,

I try with you solution but I didn't understand what to do ..

In attached qvd there is my main fact table called "Sales Line" in sales line which field need to be link..