Combining two different data set on condition in alteryx

akumar2609

I need help to combine two different data set based on the condition.
I have two data set

Data set 1
Scenario	Q1	Q2	Q3	Q4
A	123	234	345	456
B	2876	9870	9754	953
C	9087	5432	9085	1234
D	908	124	876	457

Data set 2
Scenario	Q1	Q2	Q3	Q4
A	564	234	345	456

If in Scenario column, there is "A", then combine both the data set and incase not then just give me the data set 1 in the output.

If Condition met, then
Scenario	Q1	Q2	Q3	Q4
A	123	234	345	456
B	2876	9870	9754	953
C	9087	5432	9085	1234
D	908	124	876	457
A	564	234	345	456

If Condition not met, then
Scenario	Q1	Q2	Q3	Q4
A	123	234	345	456
B	2876	9870	9754	953
C	9087	5432	9085	1234
D	908	124	876	457

ShankerV

Hi @akumar2609 

Tried with a different data set 2 where the condition will not meet.

Dataset2:

Output:

Many thanks

Shanker V

Combining two different data set on condition in alteryx.yxmd