Microsoft Secure Tech Accelerator
Apr 03 2024, 07:00 AM - 11:00 AM (PDT)
Microsoft Tech Community

Combine 2 columns in Single coulmn in KQL

Copper Contributor

Hi ,

I have data in sign-in logs as username and location, I want to combine username, location columns and add it to 3rd column. How I can do it in KQL.

I have data like- 

User NameLocation
User-1IN
User-2US
User-3GB
User-4MX

I want it like following- 

User Details
User-1 - IN
User-2 - US
User-3 - GB
User-4 - MX
1 Reply
| extend ['User Details']=strcat (['User Name'], " - ", Location)