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

Question

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 IDOPP IDMarket OfferingsAmountA11M1100A22M20A33M310A14M250A45M420

Source 2:

Corresponding Market OfferingsM1M3

Output:

Account IDOPP IDMarket OfferingsAmountFlagA11M1100YA22M20NA33M310YA14M250NA45M420N

Can Someone please help me with the solution?

ChrisTX · Answer

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

Chris

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

Andreina · Answer

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

Find-Replace.yxmd