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 · Accepted solution]

Like this?

[omar_velor]

Yes, like that! Cheers

[prakashkaur189]

A new Mapping column needs to be added using formula tool. Join all the outputs of formula and eliminate all unnecessary columns. Attached is the flow.