How to map the Dates column to date interval in alteryx

[Sharat055]

Hi,

I have two tables,

Table 1:

City        Dates

IND     12/01/2022

UAS     25/01/2022

RAS     06/01/2022

CHI       02/02/2022

Table 2:

    Date1                Date2                   Week

01/01/2022            08/01/2022                1

09/01/2022            16/01/2022                2

17/01/2022             24/01/2022               3

25/01/2022             31/01/2022               4

01/02/2022              08/02/2022               5

09/02/2022              16/02/2022               6

my output table should contain 

Output:

City        Dates                 week

IND     12/01/2022               2

UAS     25/01/2022              3

RAS     06/01/2022              1

CHI       02/02/2022              5

Please help me to map the table 1 to table 2, which tool should i use here to develop the work flow

[binuacs · Accepted solution]

@Sharat055 One way of doing this

[Qiu · Accepted solution]

@Sharat055 
Follow the approach of @binuacs I used teh Append tool instead of Generate Rows.
If your input rows is small and data range is big, then mine might be computationally cheap.

Otherwise solution of @binuacs might be better.

[Sharat055]

Thank you, its works for me.

[Sharat055]

Thank you

[Qiu]

@Sharat055 

Glad it helps