Need Final Link table

[#1]

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.

[Gysbert_Wassenaar]

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;

[#3]

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.

[Gysbert_Wassenaar]

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

[#5]

Please find the attached doc

[Gysbert_Wassenaar]

There is no doc attached.

[#7]

Which document you require..

[Gysbert_Wassenaar]

Can you post a qlikview document and the source files?

The .qvw and .qvd files

[#9]

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

[Gysbert_Wassenaar]

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