I have a table of data like so.
| Comment 1 | Comment 2 | Comment 3 |
|---|---|---|
| This is a text comment | null | null |
| null | this text comment has a number 2 | null |
| null | null | this is comment 3 |
I want to create a calculated field such that I have a column that aggregates all the data into one like so.
| Combined Comment |
|---|
| This is a text comment |
| this text comment has a number 2 |
| this is comment 3 |
I did read through GDS help documents about CONCAT and I found that the null values make it so CONCAT comes out null.
I had slightly better luck with a CASE statement when combining two of the columns but not all three.
I also tried to combine the two columns then used that combined column into another calculated field without luck.
All fields are set to text, many have a mix of alpha and numeric characters but should be treated as text. None are only numbers.
Any help is appreciated.
