like with table

Community Support
1

t1:( c:symbol$(); t:symbol$(); indu:`symbol$())

t1 insert (gm; $"LEE LIANG TOO"; $“Semi conductors”)
t1 insert (gm; $"AAAAAA BEEES BDFD KEN KONG KA"; $“Auto mobiles”)
t1 insert (ge; $"ADEGS SJDG AAADDD"; $“Diversified Industries”)

t2:( c:symbol$(); t:symbol$())

t2 insert (gm; $"KEN KONG KA") t2 insert (ge; $“TEST”)

I want to get all the data where t1.c = t2.c and t1.t like t2.t
(hardcoded works t1.t like “*KEN KONG KA*”)

Pls advise

2

q)xID N NAME---------------------“01” “ABCDEF” "*ABC*"q)select from x where N like NAMEtypeOn Aug 26, 6:03?pm, kittu <nitinvi...> wrote:&gt; t1:([] c:symbol$(); t:symbol$(); indu:symbol$())>> t1 insert (gm; $"LEE LIANG TOO"; $“Semi conductors”)> t1 insert (gm; $"AAAAAA BEEES BDFD KEN KONG KA"; $“Auto mobiles”)> t1 insert (ge; $"ADEGS SJDG AAADDD"; $“Diversified Industries”)>> t2:( c:symbol$(); t:symbol$())>> t2 insert (gm; $"KEN KONG KA")&gt; t2 insert (ge; $“TEST”)>> I want to get all the data where t1.c = t2.c and t1.t like t2.t> (hardcoded works t1.t like “KEN KONG KA”)>> Pls advise</nitinvi…>

3

X-Mailer: Apple Mail (2.936)

like’

or

any like/:

or something, depending on what exactly you’re trying to do

what you did tries to run

(enlist"ABCDEF")like enlist(“*ABC*”)

which doesn’t work

4

Thanks for reply. How can i use “like” with table column ?t1:( c:symbol$(); t:symbol$(); indu:symbol$())t1 insert (gm; $“LEE LIANG TOO”; $"Semi conductors")t1 insert (gm; $“AAAAAA BEEES BDFD KEN KONG KA”; $"Auto mobiles")t1 insert (ge; $“ADEGS SJDG AAADDD”; $"Diversified Industries")t2:([] c:symbol$(); t:symbol$())t2 insert (gm; $“KEN KONG KA”)t2 insert (ge; $"TEST")I want to get all the data of t1 table where t1.c = t2.c and t1.t liket2.t(hardcoded works t1.t like "\*KEN KONG KA\*")Pls adviseThanksOn Aug 27, 8:02?pm, Aaron Davies <aaron.dav...> wrote:&gt; like'&gt;&gt; or&gt;&gt; any like/:&gt;&gt; or something, depending on what exactly you're trying to do&gt;&gt; what you did tries to run&gt;&gt; (enlist"ABCDEF")like enlist("*ABC*")&gt;&gt; which doesn't work&gt;&gt; On Aug 27, 2010, at 8:00 AM, kittu wrote:&gt;&gt;&gt;&gt;&gt;&gt; &gt; q)x&gt; &gt; ID ? N ? ? ? ?NAME&gt; &gt; ---------------------&gt; &gt; "01" "ABCDEF" "*ABC*"&gt;&gt; &gt; q)select from x where N like NAME&gt; &gt; type>> > On Aug 26, 6:03 pm, kittu <nitinvi…> wrote:> >> t1:( c:symbol$(); t:symbol$(); indu:symbol$())&gt;&gt; &gt;&gt; t1 insert (gm; $“LEE LIANG TOO”; $"Semi conductors")&gt; &gt;&gt; t1 insert (gm; $“AAAAAA BEEES BDFD KEN KONG KA”; $"Auto mobiles")&gt; &gt;&gt; t1 insert (ge; $“ADEGS SJDG AAADDD”; $"Diversified Industries")&gt;&gt; &gt;&gt; t2:([] c:symbol$(); t:symbol$())&gt;&gt; &gt;&gt; t2 insert (gm; $“KEN KONG KA”)> >> t2 insert (ge; `$“TEST”)>> >> I want to get all the data where t1.c = t2.c and t1.t like t2.t> >> (hardcoded works t1.t like “KEN KONG KA”)>> >> Pls advise>> –> Aaron Davies> aaron.dav…@gmail.com- Hide quoted text ->> - Show quoted text -</nitinvi…></aaron.dav…>