Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

how to add excel file into existing data model

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

18 Replies
sunny_talwar

Not sure I understand your question?

HirisH_V7
Master
Master

Hi,

Post your script if possible!!

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
prma7799
Master III
Master III
Author

I want to add target.xls with existing file (copy test)

Anonymous
Not applicable

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

prma7799
Master III
Master III
Author

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

HirisH_V7
Master
Master

For which table in masters you want to append these records!!!

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
prma7799
Master III
Master III
Author

Hi Hirish,

I dont want to append these record to any table I just want to link that excel with my link table.

prma7799
Master III
Master III
Author

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;

MindaugasBacius
Partner - Specialist III
Partner - Specialist III

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:

Screenshot_1.png

Also, you'll get the right answer only if the Region names are same in both tables.