trying to simply concat two columns... killing me

[rgouette]

I am trying to concatenante two columns in a table, with an underscore between them, without using merge(because I wish to retain the original two columns as well)

I've tried the CONCATENANTE  command, AND "addColumn" to no avail, like below.

"Full Name MYNEWCOLUMNNAME= CONCATENATE(dbo_MYTABLENAME[MYFIELD#1]
&"_",dbo_MYTABLENAME[MYFIELD#2])"

and 

= Table.AddColumn(dbo_MYTABLENAME, "MYNEWCOLUMNNAME", each Table.AddColumn(dbo_dbo_MYTABLENAME,
"MYFIELD#1", each [JAXLAWSONREQUISITIONNO]+"_"+[MYFIELD#2]))

Thoughts?

Thanks much,

Richj

[Vijay_A_Verma · Accepted solution]

Insert a custom column from Add Column menu and paste the below in the box

[#"MYFIELD#1"] & "_" & [#"MYFIELD#2"]