Data Model Issue

kakani87 — Tue, 23 Jan 2018 05:56:22 GMT

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

Re: Data Model Issue

YoussefBelloum — Tue, 23 Jan 2018 09:24:27 GMT

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 ) ?