Last active
March 10, 2024 16:26
-
-
Save NonAbility/b706ffd268e533eac4a8371bf423a2fa to your computer and use it in GitHub Desktop.
30分刻み当月カレンダークエリーに当月データクエリーをマージして合成するクエリー
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
let | |
ソース = Q_Monthly_Calendar, | |
マージされたクエリ数 = Table.NestedJoin(ソース, {"年月日時間帯"}, Q_Read_CSV_RealTime, {"Date_Time"}, "Q_Read_CSV_RealTime", JoinKind.LeftOuter), | |
展開されたQ_Read_CSV_RealTime = Table.ExpandTableColumn(マージされたクエリ数, "Q_Read_CSV_RealTime", {"供給エリア", "供給力-需要", "エリア需要", "原子力", "風力_可能", "太陽光_可能", "地熱", "バイオマス", "水力", "火力_石炭", "火力_LNG", "火力_石油", "火力_その他", "その他", "蓄電池発電", "揚水発電", "連系線_入", "蓄電池充電", "揚水動力", "連系線_出", "太陽光_抑制", "風力_抑制", "正側計", "負側計", "正側計_当月最大", "負側計_当月最小"}, {"供給エリア", "供給力-需要", "エリア需要", "原子力", "風力_可能", "太陽光_可能", "地熱", "バイオマス", "水力", "火力_石炭", "火力_LNG", "火力_石油", "火力_その他", "その他", "蓄電池発電", "揚水発電", "連系線_入", "蓄電池充電", "揚水動力", "連系線_出", "太陽光_抑制", "風力_抑制", "正側計", "負側計", "正側計_当月最大", "負側計_当月最小"}), | |
並べ替えられた行 = Table.Sort(展開されたQ_Read_CSV_RealTime,{{"年月日時間帯", Order.Ascending}}), | |
Buffer = Table.Buffer(並べ替えられた行) | |
in | |
Buffer |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment