Issue with lookup table with simple name

Not applicable

HI There,

I created this query to make simple names for a custom log I have being pulled in. But for some reason its cutting all the other fields except for the one defined.


let usbNames = datatable (USBName_CF:string, Simple_Name:string)  [@"u'\\\\?\\USB#VID_05AC&PID_12A8#8118a322310937c13deeaf940dc1f9b6b2ec9da8#{a5dcbf10-6530-11d2-901f-00c04fb951ed}","Logi Group Webcam" ]; USB_CL | join kind=rightouter (usbNames) on USBName_CF




Any help would be appreicated :) 

1 Reply

Sorry I didn't realize you had posted here already.  I am adding the response here for others as well.

Since the string had a lot of special characters, we need to add @ before the string so that it doesn't intepret the special characters.


let usbNames = datatable (USBName_CF:string, Simple_Name:string) [@"u'\\\\?\\USB#VID_046D&PID_0858#7&26bcc62e&0&1#{a5dcbf10-6530-11d2-901f-00c04fb951ed}","Logi Group Webcam"];
| join kind=leftouter (usbNames) on USBName_CF
| project iif(isnull(USBName_CF),"no match",USBName_CF)