Forum Discussion

Anil Kc's avatar
Anil Kc
Copper Contributor
Mar 20, 2018
Solved

Concat two column data into one in log queries

Hi,

 

I am in a process to create alert and there I want to merge 2 columns and pass it as one. Example below:

 

  • Object - Activity + Account

Thanks.

 

  • Hi

    You can use extend and  strcat functions.

    Example:

    ... | extend New_Column = strcat(First_Column_Name, Second_Column_Name) 

1 Reply

  • Hi

    You can use extend and  strcat functions.

    Example:

    ... | extend New_Column = strcat(First_Column_Name, Second_Column_Name) 

Resources