Forum Discussion
Solved
Creating a new table using date table and items from other table
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 |
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.
2 Replies
- some_bih
Community Champion
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. Thanks for the help some_bih
