Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I have two tables: one with dates and one with a list of countries. Example:
Table 1
Date |
1/1/2022 |
1/2/2022 |
1/3/2022 |
Table 2
Countries |
France |
Germany |
Italy |
I'm trying to expand the first table in order to have, for each date, all the countries listed in Table 2. The target table would look like:
Date | Countries |
1/1/2022 | France |
1/1/2022 | Germany |
1/1/2022 | Italy |
1/2/2022 | France |
1/2/2022 | Germany |
1/2/2022 | Italy |
1/3/2022 | France |
1/3/2022 | Germany |
1/3/2022 | Italy |
Would you know how to help me?
Thank you!
try to do the opposite, that is, translate the date into the country table
pls try this
In PowerQuery it seems to work, but when I "Close & Load" the laod just keeps on going endlessly:
Consider that the largest table in this dataset is 2Gb, and the table we're creating is about 10k rows (40 countries over 250 dates), so I'm not sure about what's going
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |