topic Exists in QlikView

Exists

manoranjan_d — Mon, 19 Jun 2017 12:16:53 GMT

T1:

Id name

1 Mano

1 Ranjan

concatenate

T2:

Id name

1 Manoranjan

2 Ranjan

3 xxxx

4 yyyy

5 zzzzz

my final output table should have this output

ID Name

1 Mano

1 Ranjan

1 Manoranjan.

how to use exists i tried with T2 where exists(Id), but i m not gettign the output

MK_QSL — Mon, 19 Jun 2017 12:21:01 GMT

What is the logic behind below output?

ID Name

1 Mano

1 Ranjan

1 Manoranjan.

MK_QSL — Mon, 19 Jun 2017 12:22:37 GMT

T1:

Load * Inline

[

Id, name

1, Mano

1, Ranjan

];

concatenate

Load * Inline

[

Id, name

1, Manoranjan

2, Ranjan

3, xxxx

4, yyyy

5, zzzzz

] Where Exists (Id);