Have you tried with Normalizer transformation?
Try it with Normalizer Transformation and check the occurances as per your requirement.
what if in your source column you also have
Then, what will be the output of your target column?
I am asking this because I want to understand the logic of your target generation.
As suggested earlier , you can use the Normalizer transformation .Please refer to below document ,which has brief about how the output (which can be assigned to a target ) will be generated when a normalizer transformation is used :
Thank you .
Hey, this thread is 13(!) years old. It's quite likely that the original poster no longer needs the answer, and chances are even that this person no longer works in this technical area.
Instead of repeating what other people have written, please focus on new questions and answers which have NOT been given by other people.
My 2 cents.