Using replace_string and a datatable

Copper Contributor

Hi,

 

After some help with a kusto query please.

 

I have a datatable:

 

let ClientId = datatable (cloud_Id: string, ClientName: string)
[
"IDabc", "Client1",
"IDdef", "Client2",
"IDghi", "Client3",
"IDjkl", "Client4"
];
Clientid

 

Then within my Logs in AppInsignts ... I have a column called: cloudAlpha

 

All - I want to do is when I am returning the cloudAlpha in the main query  - I want to return the ClientName column instead.

 

I don't understand why this does not work....

 

replace_string(cloudAlpha, cloud_Id, ClientName)

 

Thanks

 

0 Replies