Data Browser

Toad Data Point & Toad Intelligence Central
1

In Data Browser, I would like to concatenate fields separated by ‘_’.

  1. Is this possible? If so, how?

  2. I would like to concatenate more than 2 columns. When I try this, I get an error. Is this possible?

2

Can you post a screenshot of the data and formula/rule you are using?

3

Here is the sample data set:

tble.png

Here is the error:

concat1.png

It seems that CONCAT only concatenates two columns.

4

You can use the following expression

Concat( Concat( [field_1], [field_2]), [field_3])

5

Thanks Aleksey. I would have never thought of using nested Concat.

Is there a way to contact with ‘_’ in between two fields?

6

Try the following

Concat( Concat( [field_1], ‘_’ ), [field_3])

7

I tried Concat( Concat( [field_1], ‘_’ ), [field_3]) and got the “Expression error…”.

It does not line the use of single quote along with Concat.

8

It works for me

1261.Capture.png
1261.Capture.png865×414 29.1 KB

9

Thanks… I realized that I had typo in my syntax.