How to merge two data sets using common field and using transform s with the help of elastic search query

Question

Using transforms in elasticsearch how to merge two datasets if the have same field for example

Table A

id name
1  a
2  b

Table B

id name
1  c
3  d

If both the ids are same then merge the datas in new table using transforms