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
HirisH_V7
Master
Master

Hi ,

You can create a  QVD with that Target Table and call like this,(By Renaming Fields as per your requirement)

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

[..\Excels\PNO\Division-Region-Tagging-Template.xls]

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

Target:

LOAD Targets,

[Business Segment],

HOD,

Region as Div_Region,

Country

[QVD];

Hope this helps,

Hirish

HirisH
“Aspire to Inspire before we Expire!”
Anonymous
Not applicable

prma7799
Master III
Master III
Author

Hi Hirish,

That is not my requirement,

now I link Div_Region to Target : Div_Region

but when I select quarter filed the data not coming for quarter.

Thanks

prma7799
Master III
Master III
Author

Any solution on this?

Anonymous
Not applicable

From which table, quarter field is taken and what is the link between the target excel and the table in which quarter field is available?

Regards,

Leni Balakrishnan

prma7799
Master III
Master III
Author

quarter is coming from MasterCalendar but still there is no link between target excel and master calendar. but in target excel month is filed is present .

Anonymous
Not applicable

Is it possible for you to share the screenshot of your datamodel?

Regards,

Leni Balakrishnan

prma7799
Master III
Master III
Author

PFA.

And also tell me how to link these target xls to the link table .

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

If your target field value is same as Financial Year value why not alias one or both field.