Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
Here I am attaching my data model pics , Here in Fact GL , I want to fetch vendore associated to gl entry ,
so I use apply map command and bring all vendore code in fact GL table , But now I want to have Vendore Names also link
along with codes .
I use following mapping
PickVendor:
Mapping Load
[Document No_] as DocNo ,
[Vendor No_] as Vend
FROM [Source QVDs NAV\FACT_QV_VendLedgerEntry.qvd]
(qvd);
fact_glentry:
load
...
IsProduct,
ApplyMap('PickVendor',[Document No_],0) AS key
FROM
[Source QVDs NAV\FACT_GL_Entry_temp.qvd]
(qvd);
Vendor:
DIM_Vendor_Master:
Directory;
LOAD
Vendor_Code,
Vendor_Code as key,
Vendor_Name
FROM
[Source QVDs NAV\DIM_Vendors.qvd]
(qvd)
WHERE Vendor_Name <> '';
This forms loops how to avoid this.
Vikas
Hi,
Try like this
Create another mapping table
Vendor:
Mapping LOAD
Vendor_Code,
Vendor_Name
FROM
[Source QVDs NAV\DIM_Vendors.qvd]
(qvd)
WHERE Vendor_Name <> '';
DIM_Vendor_Master:
Directory;
LOAD
Vendor_Code,
Vendor_Name,
Vendor_Code & '_' & Vendor_Name as Key
FROM
[Source QVDs NAV\DIM_Vendors.qvd]
(qvd)
WHERE Vendor_Name <> '';
fact_glentry:
LOAD
*,
TempVendorCode & '_' & ApplyMap('Vendor',TempVendorCode,'') AS Key;
load
...
IsProduct,
ApplyMap('PickVendor',[Document No_],0) AS TempVendorCode
FROM
[Source QVDs NAV\FACT_GL_Entry_temp.qvd]
(qvd);
Regards,
Jagan.
Thanks Jagan I will try and get back you.
Vikas