Compare two different datasets and create a third dataset based on the comparisson

omar_velor

Hi all,

I have two independent datasets(columns) that have different length. I want to compare them, and then create a thirds dataset based on such comparison. The following simple example illustrates the task.

Considering two very simple tables,

Table 1

ID
1
2
3
4
5
6
7
8

Table 2

ID

1

2

3

4

By comparing both I would like to get the following table as output of the comparison,

ID	Mapped
1	yes
2	yes
3	yes
4	yes
5	no
6	no
7	no
8	no

Trailduck

Like this?

comparison_datasets.yxmd