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
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
Why not, Partial load for same??
What is meant by partial reload? What is its use? Please explain!
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
Any solution on this?
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
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 .
Is it possible for you to share the screenshot of your datamodel?
Regards,
Leni Balakrishnan
PFA.
And also tell me how to link these target xls to the link table .
Hi,
If your target field value is same as Financial Year value why not alias one or both field.