topic Re: Join the two tables in between two field values in QlikView

Join the two tables in between two field values

Sun, 25 Aug 2013 02:38:35 GMT

Hello Folks, I am looking for solution how to join two tables in between field values.

TAB1:

TAB2:

I want join these tables on MARKTID and TIME (TAB2) must be fall in b/n START_TIME and END_TIME (TAB1).

OUTPUT:

Any thoughts, how to achieve this ?

Thanks in Advance...

Anonymous — Sun, 25 Aug 2013 04:27:37 GMT

TAB1:

load * inline [

ID,MARKETID,VALUE

11640,MPX26,22477

11642,MPX26,5226

];

TAB11:

NoConcatenate

load ID,right(MARKETID,len(MARKETID)-1) as MARKETID,VALUE

resident TAB1;

Drop Table TAB1;

TAB2:

load * inline [

MARKETID,USER

PX26,P035687

PX26,P034676

];

Anonymous — Sun, 25 Aug 2013 04:35:54 GMT

in terms of user please left(USER,len(USER)-2)

Sun, 25 Aug 2013 10:19:07 GMT

Hi,

Please find the attached application

Sun, 25 Aug 2013 11:19:30 GMT

Thanks Vikram. But I am working with very big tables.

Is there any way can I join in single load statement?

Gysbert_Wassenaar — Sun, 25 Aug 2013 12:20:23 GMT

You can use the intervalmatch function to match a value with an interval. See this blog post: IntervalMatch, and the document referenced at the end: IntervalMatch and Slowly Changing Dimensions