Concatenate numbers not working

[nesonica]

Hi guys,

I wanted to concatenate the columns D, N, and A. Unfortunately I get no results when concatenating with

=CONCAT([D],[N],[A])

Customer	D	N	A	(expected)DNA
1	1	2	2	122
2	2	2	1	221
3	3	1	1	311

Can you guys help me? 🙂 

[Shubham_Deshmukh · Accepted solution]

Use this :
=D&N&A

//Update : no use of '' in between.

[d_petrov]

You can do it in the script like: D & N & A AS Your_Column

[vishsaggi]

Did you try like

D&N&A

[vishsaggi]

BTW you should use & rather than comma for concat something lik

Concat(D&N&A, '')
or just
Concat(D&N&A)

[nesonica]

That worked perfectly, thank you! 😄