Data Model Issue

[kakani87]

Dear All,

I'm having a sale data where in that items they are categorized into TOTAL, ASC, & NEW 3 types

where TOTAL= ASC+NEW

having list of items for ASC and NEW (i.e item_names) so not able to append to fact where it is having item_code

Now  i am doing like this below script can any one help me to correct this as i'm not getting the correct results

ITEM:

LOAD itemcode,

    itemname,

    item_family_code

    //'Total' as flag

FROM

(qvd)

;

//Concatenate(ITEM)

//left join (ITEM)

ITEM_TYPE:

NoConcatenate

//Item_ASC:

LOAD [ITEM NAME_ASC] as itemname,

    'Asc' as flag

FROM

(biff, embedded labels, table is Sheet1$);

//Concatenate(ITEM)

Concatenate(ITEM_TYPE)

//left join (ITEM)

//Item_New_Sales:

LOAD [ITEM NAME] as itemname,

     'New Sale' as flag

FROM

(biff, embedded labels, table is Sheet1$);

Following is the data model

[YoussefBelloum]

Hi,

unfortunately your question/problem is not clear.

what do you mean by"so not able to append to fact where it is having item_code" ?

If total really = asc+new, you can simply flag and concatenate (why no-concatenate asc and concatenate new ) ?