Date Range from another source

[Ultralightbeam]

I have dates table below

DatesLookup table

Monday	Friday
2021-01-11	2021-01-22
2021-01-25	2021-02-05
2021-02-08	2021-02-19
2021-02-22	2021-03-05

and another table which contains "TimestampDates" column

I want to add another column where the "TimestampDates" column belongs to in a monday to friday range. 

Output will be

TimestampDates	Monday	Friday
2021-02-03	2021-01-25	2021-02-05
2021-02-09	2021-02-08	2021-02-19

[Assaf_m]

If your data set is small you can use the attached solution, otherwise, you need to use the "Generate Rows" and "Join" Tools 

let me know if this helps.

[AngelosPachis]

Hi @Ultralightbeam ,

Another way would be to use a generate rows tool to generate all dates between Monday and Friday. Then with the join tool, you can join the timestamp dates on the generated dates from the generate rows tool.

That should work for larger datasets as well, as there is no need to append.

Cheers,

Angelos