Joining with wildcarded values

%3CLINGO-SUB%20id%3D%22lingo-sub-2326445%22%20slang%3D%22en-US%22%3EJoining%20with%20wildcarded%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326445%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20join%20with%20wildcarded%20values%20such%20as%20the%20below%20with%20multiple%20fields.%20Does%20anyone%20know%20how%20to%20do%20this%20in%20KQL%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3Elet%20X%20%3D%20datatable(Name%3Astring%2C%20Src%3Astring%2C%20Dest%3Astring)%0A%5B%0A%20%20%20%20'a'%2C'42.0.0.3'%2C'10.0.0.3'%2C%0A%20%20%20%20'b'%2C'42.0.0.3'%2C'20.33.44.55'%0A%5D%3B%0Alet%20Y%20%3D%20datatable(Name2%3Astring%2C%20Src%3Astring%2C%20Dest%3Astring)%0A%5B%0A%20%20%20%20'b'%2C'42.0.0.3'%2C'10.0.*'%2C%0A%20%20%20%20'c'%2C'42.0.0.3'%2C'20.33.44.55'%0A%5D%3B%0AX%20%7C%20join%20Y%20on%20Src%2C%20Dest%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I'm trying to join with wildcarded values such as the below with multiple fields. Does anyone know how to do this in KQL?

 

 

let X = datatable(Name:string, Src:string, Dest:string)
[
    'a','42.0.0.3','10.0.0.3',
    'b','42.0.0.3','20.33.44.55'
];
let Y = datatable(Name2:string, Src:string, Dest:string)
[
    'b','42.0.0.3','10.0.*',
    'c','42.0.0.3','20.33.44.55'
];
X | join Y on Src, Dest

 

 

Many thanks

0 Replies