Creating a new table using date table and items from other table

[RahulKumarBIT]

Hi

I have a date table. I have another table having two columns - ID and category for each id. I want to create a new table which will have 2 columns - Date series from date table and ID. Following are the issues i am trying to resolve:

1) How to create the new table bringing in date series and id from the two other tables.

2) Date Series in the 1st column will repeat for each id

I have shown below a sample of two tables along with the desired output table:

1) 1st Input - Date Table:

EOM Dates

01/31/2023

02/28/2023

2) 2nd Input - ID Table:

ID

501

502

3) Output Table

EOM Dates	ID
01/31/2023	501
02/28/2023	501
01/31/2023	502
02/28/2023	502

[RahulKumarBIT]

Thanks for the help @some_bih 

[some_bih · Accepted solution]

Hi @RahulKumarBIT  after you imported your data, new table should be:

Output Table =

    CROSSJOIN('1st Input - Date Table',

    '2nd Input - ID Table'

)

If this helps please kudo.
If this solves your problem please accept it as a solution.