LinkTable Question?

MuraliPrasath — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have 3 tables with two common fields. I have to create one LinkTable for %MATNR_WERKS and MATNR and WERKS.

Need Help.

MSKU:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

MATNR,

WERKS,

KULAB

FROM [..\30_QVD\MSKU.qvd](qvd);

MSLB:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

MATNR,

WERKS,

CHARG,

SOBKZ,

FROM [..\30_QVD\MSLB.qvd](qvd);

RESB:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

MATNR,

WERKS,

ERFMG,

AUFNR,

FROM [..\30_QVD\RESB.qvd](qvd);

Re: LinkTable Question?

surendraj — Tue, 24 Jan 2017 09:53:07 GMT

MSKU:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

//MATNR,

//WERKS,

KULAB

FROM [..\30_QVD\MSKU.qvd](qvd);

MSLB:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

//MATNR,

//WERKS,

CHARG,

SOBKZ,

FROM [..\30_QVD\MSLB.qvd](qvd);

RESB:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

//MATNR,

//WERKS,

ERFMG,

AUFNR,

FROM [..\30_QVD\RESB.qvd](qvd);

link table:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

MATNR,

WERKS,

//KULAB

FROM [..\30_QVD\MSKU.qvd](qvd);

concatinate

MSLB:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

MATNR,

WERKS,

//CHARG,

//SOBKZ,

FROM [..\30_QVD\MSLB.qvd](qvd);

conacatinate

RESB:

LOAD

MATNR &'/'& WERKS as %MATNR_WERKS,

MATNR,

WERKS,

//ERFMG,

//AUFNR,

FROM [..\30_QVD\RESB.qvd](qvd);

By concatinating above 3 tables.Link Table have the only 3 feilds.

MATNR &'/'& WERKS as %MATNR_WERKS(key)

MATNR,

WERKS

Note:if you want another feilds except these,you can extract from separete tables which are located above.

--Surendra

topic Re: LinkTable Question? in QlikView

LinkTable Question?

Re: LinkTable Question?