data lose when concatenate

[capriconuser]

i have 2 qvds 

qvd 1

load 
id,
name,
p_no 

qvd2

load 
p_no,
renew_from_p_no
status

qvd2 result before concatenate

P_NO	      STATUS
DC112	       Expired
DC000215	Canceled
DC201009	Expired
DC201010	Expired

when concatenate both qvd1 and qvd2 like this

load 
id,
name,
p_no 
from table1.qvd
concatenate
load 
p_no,
renew_from_p_no
status
from tabe2.qvd
store final into [lib://new folder/final .qvd](qvd);

then i load this final qvd

load 
id,
name,
p_no,
renew_from_p_no
status
from final.qvd

after concatenate result is like this 

POLICY_NO	STATUS
DC112	Expired
DC112	-
DC000215	Canceled
DC000215	-
DC201009	Expired
DC201009	-
DC201010	Expired
DC201010	-

where as i dont want result like this 

i want result before concatenating which i got

[MayilVahanan]

Hi @capriconuser 

Hope , Qvd 2 has unique values for p_no & status. 

Instead of Concatenate, try with Left Join or Join for your requirement.