join is not working

[#1]

hello all

here is my code :

a :
LOAD REFERENCEKEYID,
STATUS,
DATE_TIME ,
USER_NAME,
OPERATION
FROM
[.......QVD\M2R_GUI_COMMENT_20160905.qvd]
(qvd) ;

LOAD DATE_APPLI,
REPORTINGID,
SOURCENAME,
ACKTRANSACTIONID as REFERENCEKEYID,
SUPERVISORPARTYNAME,
FROM
[D.......QVD\VIP_REP_M2R_DTM_ACKTRANSACTION_20160905.qvd]
(qvd) ;

can you tell me why i lose the information of the seconde qvd. ( VIP_REP_M2R_DTM_ACKTRANSACTION_20160905.qvd]).

when i create the straight table for example i cannot see  in the same line  REFERENCEKEYID and SUPERVISORPARTYNAME. (no value for SUPERVISORPARTYNAME.)

i have tried the left join and right join and concatenate but it's not working.

i attached a scrrenshot.

thank in advance for your help.

[effinty2112]

Hi Ferhat,

                    What is the subset ratio for this field in the other table?. If it is 99.24% then that would suggest that there are no common values for that field in the two tables.

Kind regards

Andrew

[#3]

Hi,

i had a similar problem with number formatting. if text doesn't work try something like this:

a :
LOAD

'X-'&REFERENCEKEYID AS REFERENCEKEYID,
STATUS,
DATE_TIME ,
USER_NAME,
OPERATION
FROM
[.......QVD\M2R_GUI_COMMENT_20160905.qvd]
(qvd) ;

LOAD DATE_APPLI,
REPORTINGID,
SOURCENAME,
'X-'&ACKTRANSACTIONID as REFERENCEKEYID,
SUPERVISORPARTYNAME,
FROM
[D.......QVD\VIP_REP_M2R_DTM_ACKTRANSACTION_20160905.qvd]
(qvd) ;