回答率: 85.30%

質問するログイン新規登録

トップ Excelに関する質問パワークエリの一部をパラメータ（変数にしたい）

編集履歴

質問編集履歴

1

コードを更新

2025/04/22 06:55

投稿

スコア14

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -10,7 +10,7 @@
 ```
 let
-    ソース = Odbc.Query("dsn=Hakone", "SELECT COALESCE(株式残高.[Base Market Value],0)+ COALESCE(未収配当,0) AS 時価総額, *#(lf)FROM ((SELECT [Security ID] from t_bbh_portfolio_investments where [Accounting Date]='2025/02/28' and [Entity Number]='9999' and [Investment Type Code]='EQ'Union select [Security ID] from t_bbh_open_dividend_and_reclaim_receivables where [Accounting Date]='2025/02/28' and [Entity Number]='9999')  AS master LEFT JOIN (SELECT * FROM t_bbh_portfolio_investments WHERE [Accounting Date]='2025/02/28' and [Entity Number]='9999' and [Investment Type Code]='EQ')  AS 株式残高 ON 株式残高.[Security ID] = master.[Security ID]) LEFT JOIN (SELECT [Accounting Date], [Entity Number], [Security ID], Sum([Base Market Value Receivable]) AS 未収配当 FROM t_bbh_open_dividend_and_reclaim_receivables WHERE [Accounting Date]='2025/02/28' and [Entity Number]='9999' GROUP BY [Accounting Date], [Entity Number], [Security ID])  AS 未収 ON 未収.[Security ID] = master.[Security ID];#(lf)")
+    ソース = Odbc.Query("dsn=db", "SELECT COALESCE(株式残高.[Base Market Value],0)+ COALESCE(未収配当,0) AS 時価総額, *#(lf)FROM ((SELECT [Security ID] from t1 where [Accounting Date]='2025/02/28' and [Entity Number]='9999' and [Investment Type Code]='EQ'Union select [Security ID] from t2 where [Accounting Date]='2025/02/28' and [Entity Number]='9999')  AS master LEFT JOIN (SELECT * FROM t1 WHERE [Accounting Date]='2025/02/28' and [Entity Number]='9999' and [Investment Type Code]='EQ')  AS 株式残高 ON 株式残高.[Security ID] = master.[Security ID]) LEFT JOIN (SELECT [Accounting Date], [Entity Number], [Security ID], Sum([Base Market Value Receivable]) AS 未収配当 FROM t2 WHERE [Accounting Date]='2025/02/28' and [Entity Number]='9999' GROUP BY [Accounting Date], [Entity Number], [Security ID])  AS 未収 ON 未収.[Security ID] = master.[Security ID];#(lf)")
 in
     ソース
 ```