topic Re: Link Problem Data Model in QlikView

Link Problem Data Model

vikasmahajan — Thu, 27 Feb 2014 06:39:39 GMT

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

Re: Link Problem Data Model

jagan — Thu, 27 Feb 2014 06:56:16 GMT

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.

Re: Link Problem Data Model

vikasmahajan — Thu, 27 Feb 2014 06:58:29 GMT

Thanks Jagan I will try and get back you.

Vikas