Hi team, I have 2 data sets, which needs to be combined, interim dividend or final dividend the result should be Mandatory with choice DATAInterim DividendFinal DividendStock SplitRights Issue Bonus IssueMandatoryStock SplitMandatoryReverse SplitMandatoryMerger & AcquisitionMandatoryDividendMandatory with ChoiceRight IssueVoluntaryShare Buy-BackVoluntary ResultTypeInterim DividendMandatory with ChoiceFinal DividendMandatory with ChoiceStock SplitMandatoryRight IssueVoluntary

Find & Replace Tool

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

Datasets

Find&Replace can make it.

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.

Find&Replace can make it.