Hello,
I am using the String Concatenator to join two fields and separate them with a comma.
However some fields are blank so I end up with some records that contain a comma only and others that contain a comma and then the value of one of the fields.
My current setup looks like below
generally works well, except for some results like these
Is it possible to modify existing Transformer or is a different one more suitable?
My only other thought is to perform some sort of trim on an other transformer after this one to remove first character?
Thank you