so this is working
To be sure, you could try something like:
SUBSTRING(TRIM([Business Unit]), 1, 3) == "MFM" ? SUBSTRING(TRIM([Business Unit]), 4, 50): [Business Unit]
I would like to evaluate one more condition and wondering if you can help.
In total I would like to evaluate
1. if one occurrence of the DT_WSTR string '%COST POOL%' exists in column [Description 01]<-----this is the additional condition
2. and if it does to proceed with the above string, ie. evaluation of the existence of "MFM" in the first 3 letters of [Business Unit] column
3. and finally, if that evaluates to true, the extraction of the substring to the right of "MFM" in [Business Unit].
I've tried this but it doesn't parse:
FINDSTRING([Description 01], "COST POOL", 1))==1?:(SUBSTRING(TRIM([Business Unit]), 1, 3) == "MFM" ? SUBSTRING(TRIM([Business Unit]), 4, 50): [Business Unit])
I plan to put it into the Conditional Split transformation. Can you help me with the Expression?