Find & Replace Tool

[BRRLL99]

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 Issue	Mandatory
Stock Split	Mandatory
Reverse Split	Mandatory
Merger & Acquisition	Mandatory
Dividend	Mandatory with Choice
Right Issue	Voluntary
Share Buy-Back	Voluntary

Result	Type
Interim Dividend	Mandatory with Choice
Final Dividend	Mandatory with Choice
Stock Split	Mandatory
Right Issue	Voluntary

[luigi_zezza]

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 · Accepted solution]

Find&Replace can make it.