Scenario Logic Help

[abhaysingh]

Hi Every One,

Pls find the attached QVW and Sample Data with it,

In this u will see the DataModel Having Synthetic keys, and expected output in Table at GUI,

In table Holidays calendar, there are Holidays w.r.t Plant code , profit centre and material group, in second excel there is data w.r.t.

Plant code , profit centre ,material group,division,and  itemcode

if i join these table to get the data w.r.t division,and  itemcode in Holidays calendar my data is getting multiplying and getting wrong output,

so what is the other way to get the data for working calendar for dimension Division and itemcode as well, Count of Holidays available in excel should not increase, the same value shud repeat to Division and relevant itemcode. as showed in output expected table.

Hope m clear with what i want.

in short i want to remove that sync key and want

division,and  itemcode dimension in working calendar table with expected output

pls suggest

thanks

[Gysbert_Wassenaar]

Simply join the two tables together into one table.

Tab1:

LOAD trim(Plant) as PlantCode,

  trim([Profit Centre]) as Profit_Centre,

     trim([Material Group]) as Material_Grp,

     Date(Date#(Holidays,'DD.MM.YYYY'),'DD-MM-YYYY') as Holidays,

  month(    Date(Date#(Holidays,'DD.MM.YYYY'),'DD-MM-YYYY') ) as month

FROM

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

JOIN (Tab1)

LOAD PlantCode,

     Profit_Centre,

     Material_Grp,

     Itemcode,

     Division

FROM

C:\Users\admin\Desktop\MasterDataCommunity.xls

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