append a column to another column

Question

Hi, i have created a calculated column that i want to append with the another measure. My data consists of details of freshers joining the company. The offer letter needs to be sent and filename to be organize in terms of Id - Mon - Year -  Locn in . I want to have the column as said before to have a list.

Answer 1

Hi Priya,

You can use concatenate to join field values.

Syntax of CONCATENATE(str2,str2)

For your question, you can use multiple concatenate() using delimiter in between to combine them.

concat =  CONCATENATE([id],CONCATENATE("-",CONCATENATE([Mon],CONCATENATE("-",CONCATENATE([year],CONCATENATE("-",[Locn])))))).

Hope it helps you.