Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

prma7799
Honored Contributor 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

Re: how to add excel file into existing data model

Not sure I understand your question?

hirishv7
Honored Contributor

Re: how to add excel file into existing data model

Hi,

Post your script if possible!!

-Hirish

prma7799
Honored Contributor III

Re: how to add excel file into existing data model

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

leni_balakrishn
Contributor III

Re: how to add excel file into existing data model

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
Honored Contributor III

Re: how to add excel file into existing data model

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

hirishv7
Honored Contributor

Re: how to add excel file into existing data model

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

-Hirish

prma7799
Honored Contributor III

Re: how to add excel file into existing data model

Hi Hirish,

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

prma7799
Honored Contributor III

Re: how to add excel file into existing data model

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
Valued Contributor II

Re: how to add excel file into existing data model

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.

Community Browser