topic Re: Need Final Link table in QlikView

Need Final Link table

Fri, 20 Nov 2020 18:02:30 GMT

I have join all the tables but I could not able to get NEW_PRHA_REQ_NUMBER field in final table .

I want all five tables record in one final table.

Columns which I required in final table is:

NAME,

NEW_PHA_PO_NUMBER
NEW_PRHA_REQ_NUMBER
ITEM_DESCRIPTION

NEW_HOU:
LOAD
ORGANIZATION_ID,
NAME

FROM
[..\Qvds\HOU.qvd]
(qvd);

NEW_PHA:
LOAD
PO_HEADER_ID ,
ORG_ID as ORGANIZATION_ID ,
SEGMENT1 as NEW_PHA_PO_NUMBER

FROM
E:\Live\QvApp\Qvds\PHA.qvd
(qvd);

NEW_PLA:
LOAD PO_LINE_ID,
PO_HEADER_ID,
           ITEM_ID,
ITEM_DESCRIPTION

FROM
E:\Live\QvApp\Qvds\PLA.qvd
(qvd);

NEW_PLLA:
LOAD
PO_HEADER_ID as NEW_PLLA_PO_HEADER_ID ,
         PO_LINE_ID,
LINE_LOCATION_ID

FROM
E:\Live\QvApp\Qvds\PLLA.qvd
(qvd);

NEW_PRLA:
LOAD REQUISITION_LINE_ID,
REQUISITION_HEADER_ID,
LINE_LOCATION_ID

FROM
E:\Live\QvApp\Qvds\PRLA.qvd
(qvd);

NEW_PRHA:
LOAD      REQUISITION_HEADER_ID,
                 SEGMENT1 as NEW_PRHA_REQ_NUMBER

FROM
E:\Live\QvApp\Qvds\PRHA.qvd
(qvd);

Request you to please give the solution as soon as possible.

Re: Need Final Link table

Gysbert_Wassenaar — Mon, 09 Mar 2015 08:42:51 GMT

Result:
LOAD ORGANIZATION_ID, NAME FROM [..\Qvds\HOU.qvd] (qvd);
JOIN(Result)
LOAD PO_HEADER_ID , ORG_ID as ORGANIZATION_ID , SEGMENT1 as NEW_PHA_PO_NUMBER FROM E:\Live\QvApp\Qvds\PHA.qvd (qvd);
JOIN(Result)
LOAD PO_LINE_ID,PO_HEADER_ID, ITEM_DESCRIPTION FROM E:\Live\QvApp\Qvds\PLA.qvd (qvd);
JOIN(Result)
LOAD PO_LINE_ID, LINE_LOCATION_ID FROM E:\Live\QvApp\Qvds\PLLA.qvd (qvd);
JOIN(Result)
LOAD REQUISITION_HEADER_ID, LINE_LOCATION_ID FROM E:\Live\QvApp\Qvds\PRLA.qvd (qvd);
JOIN(Result)
LOAD REQUISITION_HEADER_ID, SEGMENT1 as NEW_PRHA_REQ_NUMBER FROM E:\Live\QvApp\Qvds\PRHA.qvd (qvd);


DROP FIELDS ORGANIZATION_ID, PO_HEADER_ID, LINE_LOCATION_ID REQUISITION_HEADER_ID FROM Results;

Re: Need Final Link table

Mon, 09 Mar 2015 09:45:45 GMT

In Straight Table I cant get any records against requisition number.

for eg : Name, PO Numbr,Item description data can been seen but no data appears in requisition number field.

It shows blank.

Re: Need Final Link table

Gysbert_Wassenaar — Mon, 09 Mar 2015 09:49:51 GMT

Can you post a qlikview document and the source files? Otherwise it will be next to impossible to check what's going on.

Re: Need Final Link table

Mon, 09 Mar 2015 10:23:42 GMT

Please find the attached doc

Re: Need Final Link table

Gysbert_Wassenaar — Mon, 09 Mar 2015 10:28:08 GMT

There is no doc attached.

Re: Need Final Link table

Mon, 09 Mar 2015 10:31:44 GMT

Which document you require..

Re: Need Final Link table

Gysbert_Wassenaar — Mon, 09 Mar 2015 10:34:48 GMT

Can you post a qlikview document and the source files?

The .qvw and .qvd files

Re: Need Final Link table

Mon, 09 Mar 2015 10:46:30 GMT

It is not possible me to share all qvw and qvd files....can you please let me know other way workaround.

Re: Need Final Link table

Gysbert_Wassenaar — Mon, 09 Mar 2015 11:01:20 GMT

Check your data. Make sure that the keys of a record exist in both tables used in a join.