Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find & Replace Tool

BRRLL99
11 - Bolide

Hi team,

 

I have 2 data sets, which needs to be combined, interim dividend or final dividend the result should be Mandatory with choice

 

DATA
Interim Dividend
Final Dividend
Stock Split
Rights Issue

 

Bonus IssueMandatory
Stock SplitMandatory
Reverse SplitMandatory
Merger & AcquisitionMandatory
DividendMandatory with Choice
Right IssueVoluntary
Share Buy-BackVoluntary

 

ResultType
Interim DividendMandatory with Choice
Final DividendMandatory with Choice
Stock SplitMandatory
Right IssueVoluntary
2 REPLIES 2
luigi_zezza
5 - Atom

You can use a Formula like this:

IF Contains([DATA], 'Dividend', 1) THEN 'Dividend' ELSE [DATA] ENDIF

 

and use the new field to join the tables.

sparksun
11 - Bolide

Find&Replace can make it.

sparksun_0-1657792767780.png

 

 

Labels