topic Re: Join 2 tables with differents fields in QlikView

Join 2 tables with differents fields

suzel404 — Thu, 24 Apr 2014 22:30:17 GMT

Hi all,

I have a problematic. I want to join 2 tables in one when the Dist is between StartDist and EndDist.

But fields are not in common.

For example:

Table1:

LOAD

Filed1,

Field2,

StartDist,

EndDist,

FROM File1.qvd(qvd);

Table2:

LOAD

Filed111,

Field222,

Filed333,

Dist

FROM File2.qvd(qvd)

WHERE Dist <= StartDist AND Dist >= EndDist;

How can I realize it ?

Thank for your help.

Re: Join 2 tables with differents fields

suzel404 — Thu, 24 Apr 2014 23:07:19 GMT

Correction : WHERE Dist >= StartDist AND Dist <= EndDist;

Re: Join 2 tables with differents fields

Thu, 24 Apr 2014 23:22:53 GMT

maybe you like to use IntervalMatch?

regards

Darek

Re: Join 2 tables with differents fields

suzel404 — Thu, 24 Apr 2014 23:30:14 GMT

Hi Dariusz,

InrtervalMatch works only with date, no ?

Re: Join 2 tables with differents fields

Thu, 24 Apr 2014 23:39:11 GMT

The IntervalMatch prefix is used to create a table matching discrete numeric values to one or more numeric intervals.

regards

Darek

Re: Re: Join 2 tables with differents fields

MarcoWedel — Fri, 25 Apr 2014 01:19:54 GMT

data files for tests

Re: Re: Re: Join 2 tables with differents fields

MarcoWedel — Fri, 25 Apr 2014 01:23:52 GMT

Hi Joshua,

like Darek suggested, you could use the IntervalMatch prefix e.g. like this:

Table1:

LOAD StartDist,

EndDist,

Store_Id

FROM http://community.qlik.com/servlet/JiveServlet/download/515682-103548/QlikCommunity_Thread_115537_Table1.qvo

(txt, utf8, embedded labels, delimiter is '\t', msq);

Table2:

LOAD Dist,

Price

FROM http://community.qlik.com/servlet/JiveServlet/download/515682-103549/QlikCommunity_Thread_115537_Table2.qvo

(txt, utf8, embedded labels, delimiter is '\t', msq);

tabLink:

IntervalMatch(Dist)

LOAD Distinct

StartDist,

EndDist

Resident Table1;

regards

Marco

Re: Re: Re: Re: Join 2 tables with differents fields

suzel404 — Fri, 25 Apr 2014 01:51:22 GMT

Hi Marco,

Thank for you response but is it possible to have one table ?

Re: Join 2 tables with differents fields

jagan — Fri, 25 Apr 2014 02:13:51 GMT

Hi,

Check this thread hope it helps you.

IntervalMatch

Regards,

Jagan.

Re: Join 2 tables with differents fields

suzel404 — Fri, 25 Apr 2014 05:55:12 GMT

Thanks at all for your help.