Hi,
Is there a concat functionality from Toad Data Point (Data Transform and Cleanse). I need to combine firstN, LastN, Title, and Suffix.
I see the option to split, trirm, etc., but not for concat column.
Thank you in advance.
Min
Hi,
Is there a concat functionality from Toad Data Point (Data Transform and Cleanse). I need to combine firstN, LastN, Title, and Suffix.
I see the option to split, trirm, etc., but not for concat column.
Thank you in advance.
Min
Yes, there's Concatenation, and a host more "operations" that can be performed... typically done by creating a Calculated Column. You may have to untick the Use SQL Transforms check box. See snap below.
Thank you. That would work!
