Create QVD

[#1]

T1:

ID	Name
1	er
2	fsdf
3	dfsd

T2:

ID	text
7	nm
8	f
9	j

T3:

ID	COM
1	cvd
2	df
3	v
4	sd
5	sdf
6	sdfa
7	fd
8	dffd
9	sfdf

I have 3 tables  and a create QVD shold be created on below conditions:

1)T3.ID = T1.ID

2)T3.ID = T2.Id

and the final Qvd will be created as below

  expected output:  

ID	COM	Name	text
1	cvd	er
2	df	fsdf
3	v	dfsd
7	fd		fd
8	dffd		dffd
9	sfdf		sfdf

[#2]

As per my requirement
Result:
LOAD ID, Name

FROM T1.qvd (qvd)
where Name = 'er';

CONCATENATE (Result)

LOAD ID, text

FROM T2.qvd (qvd);

JOIN (Result)

LOAD ID, COM

FROM T3.qvd (qvd)

WHERE EXISTS(ID, ID);

T1 and T3 are having 20 millions of data
So I need to pull the records based on above conditions
But  it is not working as expected.

[#3]

T1

load id,name

resident(normal file or in line table) t1;

T2

load id,name

resident t2;

T3

load *

resident t3

where Exists(id(//t1),id(//t3)) and Exists(id(t2),id(t3))

store t3 in te.qvd

[Gysbert_Wassenaar]

If you're not supposed to pull the complete data of T3 then I think you have no choice but to create an sql query that generates a result set on the database server that only contains the data you are allowed to pull. If you do the joining in Qlikview then you will need to pull all the data first before you can discard the records you don't need using joins and/or the Exists function.

[MarcoWedel]

and "not working as expected" means ?

[MarcoWedel]

please close some of your 12 open threads if you received correct answers.

thanks

regards

Marco