Discussion Board for collaboration related to QlikView Deployment.
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.
Not sure I understand your question?
Post your script if possible!!
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.
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 ?
For which table in masters you want to append these records!!!
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
if(Div_Region = 0,1,if(ISNULL(Div_Region) OR LEN(Div_Region)=0,1,0)) AS IsMissingProductGrp
(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.
Also, you'll get the right answer only if the Region names are same in both tables.