Date Range from another source

Question

I have dates table below

DatesLookup table

MondayFriday2021-01-112021-01-222021-01-25 2021-02-052021-02-08 2021-02-192021-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

TimestampDatesMondayFriday2021-02-032021-01-25 2021-02-052021-02-092021-02-082021-02-19

AngelosPachis · Answer

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

example.yxmd

Assaf_m · Answer

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.

Dates Join.yxmd