Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Deal All,
I have one application the data model is already build but now i want to add one more excel file to that, So I have added it successfully but my target fields is not associate with financial year and other fields which is present in data model.
Thansk
Not sure I understand your question?
Hi,
Post your script if possible!!
-Hirish
I want to add target.xls with existing file (copy test)
First you need to understand the relationship between the existing datamodel and the new excel file. Then based on the business requirement need to link the data in excel with the existing datamodel.
Regards,
Leni Balakrishnan
Hi Leni,
I have common field in target.xls that is region ,country ,Business Segment on the basis of that I have link region to Div_Region in master tab.
Is there is need to create link key ?
Thanks
For which table in masters you want to append these records!!!
-Hirish
Hi Hirish,
I dont want to append these record to any table I just want to link that excel with my link table.
I have link below xls file with "DIM_Division_Region:" table
DIM_Division_Region:
LOAD
// Div_Code,
Div_Name,
Div_Region,
if(Div_Region = 0,1,if(ISNULL(Div_Region) OR LEN(Div_Region)=0,1,0)) AS IsMissingProductGrp
FROM
[..\Division-Region-Tagging-Template.xls]
(biff, embedded labels, table is [Sheet1$]);
Targ_temp:
CrossTable(Month, Targets, 4)
LOAD [Business Segment],
HOD,
Region,
Country,
April,
May,
June,
July,
Aug,
Sept,
Oct,
Nov,
Dec,
Jan,
Feb,
Mar
FROM
[..\Excels\PNO\Targets International Formulation FY16.xls]
(biff, embedded labels, header is 1 lines, table is Prashant$, filters(
Remove(Row, Pos(Top, 40)),
Remove(Col, Pos(Top, 23)),
Remove(Col, Pos(Top, 22)),
Remove(Col, Pos(Top, 21)),
Remove(Col, Pos(Top, 17)),
Remove(Col, Pos(Top, 13)),
Remove(Col, Pos(Top, 9)),
Remove(Col, Pos(Top, 1))
));
Taget:
LOAD Targets,
[Business Segment],
HOD,
Region as Div_Region,
Country
Resident Targ_temp;
As I understand you want to connect Targets.xls to DIM_Division_Region table.
Tables only connect between if they have the same key.
The same applies to your data model.
For example:
Also, you'll get the right answer only if the Region names are same in both tables.