Designer | how to check/compare 2 column values and return 3rd column data

[PB41091]

I have 2 data set.

Data Set 1

A	B	C
1	0.01	5
1	0.05	5
1	0.1	5
1	0.2	10
1	0.5	40
2	0.01	30
2	0.05	30
2	0.2	20

Data Set 2

A	B	D
1	0.01	7
1	0.05	4
1	0.1	8
1	0.2	2
1	0.5	4
2	0.01	9
2	0.05	56
2	0.2	8

and I want output as

A	B	C	D
1	0.01	5	7
1	0.05	5	4
1	0.1	5	8
1	0.2	10	2
1	0.5	40	4
2	0.01	30	9
2	0.05	30	56
2	0.2	20	8

I tried union, but it is simply appending the data, by using join I have to give only unique 1 column, where as I have to check condition --> if cloumn A has 1 and column B has 0.2 then return 2 in new column of data set 1.

[JarekSkudrzyk · Accepted solution]

@PB41091 use join tool on columns A and B:

[SPetrie]

You can join on multiple fields.

Once you select your first comparison, the dropdown to select a second will appear

[PB41091]

Thank you. It works. Never thought its that simple.

[JarekSkudrzyk]

Glad I could help:)