Forum Discussion

Prashali_Shinde's avatar
Prashali_Shinde
Copper Contributor
Jan 16, 2023

Combine 2 columns in Single coulmn in KQL

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

Resources