How to create a flag(Calculated field) using two sources in Alteryx?

[Venamma]

Hi Team,

I have two sources as mentioned below and I'm trying to create a calculated field Which can check the presence of the list of Corresponding Market offerings from second table in the first source.

Join wouldn't be the best solution here.

Source 1:

Account ID	OPP ID	Market Offerings	Amount
A1	1	M1	100
A2	2	M2	0
A3	3	M3	10
A1	4	M2	50
A4	5	M4	20

Source 2:

Corresponding Market Offerings

M1

M3

Output:

Account ID	OPP ID	Market Offerings	Amount	Flag
A1	1	M1	100	Y
A2	2	M2	0	N
A3	3	M3	10	Y
A1	4	M2	50	N
A4	5	M4	20	N

Can Someone please help me with the solution? 

[Andreina]

Hello @Venamma ,

I've done it this way:

1) Create a field called Flag with "Y" value next after Source 2

2) Use Find-Replace tool with "Append Fields To Record " configuration and Append new field Flag 

3) Replace null values with "N" values

Here you'll find attached  the workflow,

Hope it helps, 

Andreina

[ChrisTX]

You can use Join, but you'll need to add a Union to combine the joined and left-unjoined data streams.

Chris