Exists

[manoranjan_d]

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]

What is the logic behind below output?

ID Name

1 Mano

1 Ranjan

1 Manoranjan.

[MK_QSL]

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);