Data transformation - adding new column

[howyoudoing]

Hi All,

I need help on that - how to from the data get the new one with new column like below? Which tool I should use?

I need the current data in the attachment with the new column - SUBJECT which should be as below:

SALES number	Name	SUBJECT
549300TECZFP4RC3RN89	NEUBERGER BERMAN SINGAPORE PTE LTD	sales exception – NEUBERGER BERMAN SINGAPORE PTE LTD – Not Onboarded
B1CG1NRZIDDJ0DQEXB52	FRANKLIN ADVISERS, INC.	sales exception – FRANKLIN ADVISERS, INC. – Not Onboarded
969500X1Y8G7LA4DYS04	NEUBERGER BERMAN SINGAPORE PTE LTD	sales exception – FRANKLIN ADVISERS, INC. – Not Onboarded

Thank  you!

[flying008 · Accepted solution]

Hi, @howyoudoing 

FYI.

IIF(IsEmpty([SALES number]), Null(), 'sales exception – ' + [Name] + '– Not Onboarded')