Just got started with qsql.
how to I compare 2 columns of type string. childID and parentID are of type string
select from data where childID like parentID
If it’s an exact match you can use Match Each ~'.
select from data where childID ~' parentID
View solution in original post
If it's not an exact match, you could wrap the second column in wildcards characters and use Like Each like'
select from data where childID like' ("*",'parentID,'"*")
Note - this assumes that the parentID has less characters than childID
Tel: +44 (0)28 3025 2242
Tel: +1 (212) 447 6700
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.