Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
Hi @RahulKumarBIT after you imported your data, new table should be:
Proud to be a Super User!
Hi @RahulKumarBIT after you imported your data, new table should be:
Proud to be a Super User!
User | Count |
---|---|
57 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |