merge qvds in sense

[capriconuser]

i have two qvds.. for e.g.

qvd1

load 
id,
contract,
name,
gross
from abc.qvd

and from this qvd the result is like this 

id                       contract

D5-310047                contractname2

and another qvd is like this 

load 
mem_key
name, 
gross
from xyz.qvd

so when i concatenate and when i drag fields id and contract this shows like this 

id                       contract

D5-310047                      -
-                          contractname2

how i got result same as above when i load qvd without concatenate

why this '-' occur in data?

any help

[MayilVahanan]

Hi @capriconuser 

I think, for your scenario, you don't want to concatenate. 

You can load the 2 qvds as it, Qlik will join the field the table based on "Name" field & it will give expected results.

[capriconuser]

but when i do join .. my script is hang and takes too much time 

[MayilVahanan]

Hi @capriconuser 

you don't need to join the tables.. you can load the 2 qvds alone, due to the common name, 2 tables have link automatically. 

FYI: In table viewer, you can see 2 tables have a line between them based on Name field. 

[capriconuser]

yes but if table has same name they create synthetic key ... join is based on IDs.