topic join on like in QlikView

join on like

Fri, 17 Feb 2012 16:19:32 GMT

hi,

Do you know how make a join on a like.

ID1= ID2 become ID1 like ID2

When I named both ID tthis the same name I have a join on equal only.

Thanks by advance.

Eva

join on like

CELAMBARASAN — Fri, 17 Feb 2012 16:53:36 GMT

Hi,

Use this approach

TableName:

Load

ID1..

From..

Left join(TableName)

Load

ID2 as ID1..

From..

Hope it will help you

Celambarasan

join on like

Fri, 17 Feb 2012 17:10:25 GMT

Hi, thanks for your answer but

I would like join if ID1 = 123 and ID2 = 123 45

I tried and that join if ID1= ID2 only.

join on like

tresB — Fri, 17 Feb 2012 17:28:24 GMT

You can only use the join clause to join on the equality of one or many fields. If they're ALL equal, then it's a match, if not, then not. The only operators supported in the join clause are 'and' and 'equals'. If you only use inner join, then you could use a cross join instead to emulate an inner join and filter in the where condition, e.g:

Code Snippet

From a in db.Table1 _

From b in db.Table2 _

Where a.Something=b.Something And a.SomethingElse.StartsWith("a")

Regards, tresesco

Re: join on like

john_duffy — Fri, 17 Feb 2012 19:09:25 GMT

Hi Eva.

I tried a different approach:

Create a cartesian product with the two tables.

Use the length of ID1 to match to ID2 (ie.if (ID1 = left(ID2,length of ID1).

See the attched example.

John.

join on like

Fri, 17 Feb 2012 19:19:55 GMT

Thnaks, that is a really good idea (specially for a friday) !! thanks for your help.

(I just hope it will work this my hudge table)