Toad World® Forums

Combine multiple columns to one


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.


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.

1 Like

Thank you. That would work!