Combine multiple columns to one

[minuzz]

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

[Gary.Jerep]

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.

[minuzz]

Thank you. That would work!