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.  
Azure Log Analytics
azure monitor
  • Stanislav_Zhelyazkov's avatar
    Stanislav_Zhelyazkov
    Mar 21, 2018

    Hi

    You can use extend and  strcat functions.

    Example:

    ... | extend New_Column = strcat(First_Column_Name, Second_Column_Name)
Stanislav_Zhelyazkov's avatar
Stanislav_Zhelyazkov
MVP
Mar 21, 2018

Hi

You can use extend and  strcat functions.

Example:

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

Resources