Insert new column with another data table

[sebastien]

Hi all,

I wish to know what is the best way to do this scenario.

I have two tables :

Hours : (ID_USER, HOURS_NUMBER, DATE)

Calendar : (YEAR, MONTH, START_DATE, END_DATE)

I need two add in Hours table the concat value of the field YEAR and MONTH of the Calendar table when DATE of Hours table is between START_DATE and END_DATE of the Calendar table

Of course only one row is possible in Calendar table.

New Hours table : ID_USER, HOURS_NUMBER, DATE, PERIOD

I hope it's clear enought to help me and thank you

[Channa · Accepted solution]

did you try with intervalmatch

[sebastien]

Thank for your answer. Sorry but I am novice on Qlik.

I try this example :

IntervalMatch_Table:
IntervalMatch(DATE)
LOAD SART_DATE, END_DATE
resident Calendar;

It's ok for the math value but I need to insert the concatenate value of YEAR and MONTH field in a new field of the Hours table.

This example generate a table with DATE, START_DATE and END_DATE only.