Discussion Board for collaboration on QlikView Scripting.
Hello Folks, I am looking for solution how to join two tables in between field values.
I want join these tables on MARKTID and TIME (TAB2) must be fall in b/n START_TIME and END_TIME (TAB1).
Any thoughts, how to achieve this ?
Thanks in Advance...
load * inline [
load ID,right(MARKETID,len(MARKETID)-1) as MARKETID,VALUE
Drop Table TAB1;
Please find the attached application
Thanks Vikram. But I am working with very big tables.
Is there any way can I join in single load statement?
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