{"type":"rich","image_url":null,"author_url":"https://blog.hatena.ne.jp/potisan/","width":"100%","url":"https://potisan-programming-memo.hatenablog.jp/entry/2021/12/21/230309","blog_url":"https://potisan-programming-memo.hatenablog.jp/","published":"2021-12-21 23:03:09","version":"1.0","provider_url":"https://hatena.blog","categories":["Power Query M","\u307e\u3068\u3081\u672a\u767b\u9332\uff08\u7ba1\u7406\u7528\uff09"],"blog_title":"potisan\u306e\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30e1\u30e2","provider_name":"Hatena Blog","author_name":"potisan","height":"190","title":"Power Query M \u30c6\u30fc\u30d6\u30eb\u306e\u5217\u540d\u3092\u5148\u982d\u30fb\u672b\u5c3e\u304b\u3089\u306e\u500b\u6570\u30fb\u6761\u4ef6\u4e00\u81f4\u3067\u629c\u304d\u51fa\u3059","description":"Power Query M\u3067\u30c6\u30fc\u30d6\u30eb\u306e\u5217\u540d\u3092\u5148\u982d\u30fb\u672b\u5c3e\u304b\u3089\u500b\u6570\u3042\u308b\u3044\u306f\u6761\u4ef6\u4e00\u81f4\u3067\u62bd\u51fa\u3059\u308b\u30b3\u30fc\u30c9\u3067\u3059\u3002 let // \u5217\u540d\u7528\u306e\u30c0\u30df\u30fc\u30c6\u30fc\u30d6\u30eb \u30c6\u30fc\u30d6\u30eb1 = #table( {\"\u52171\", \"\u52172\", \"\u52173\", \"\u52174\", \"\u52175\", \"A\", \"B\", \"C\"}, {} ), // \u5217\u540d\u306fTable.ColumnNames\u95a2\u6570\u3067\u30ea\u30b9\u30c8\u3068\u3057\u3066\u53d6\u308a\u51fa\u305b\u307e\u3059\u3002 // \u30ea\u30b9\u30c8\u306e\u901a\u5e38\u64cd\u4f5c\u3067\u5217\u540d\u306e\u4e00\u90e8\u3092\u53d6\u308a\u51fa\u305b\u307e\u3059\u3002 \u5217\u540d\u306e\u4e00\u90e8 = [ \u5217\u540d = Table.ColumnNames(\u30c6\u30fc\u30d6\u30eb1), \u5148\u982d3 = List.FirstN(\u5217\u540d, 3), \u672b\u5c3e3 = List.LastN(\u5217\u540d, 3), \u5148\u982d3\u2026","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fpotisan-programming-memo.hatenablog.jp%2Fentry%2F2021%2F12%2F21%2F230309\" title=\"Power Query M \u30c6\u30fc\u30d6\u30eb\u306e\u5217\u540d\u3092\u5148\u982d\u30fb\u672b\u5c3e\u304b\u3089\u306e\u500b\u6570\u30fb\u6761\u4ef6\u4e00\u81f4\u3067\u629c\u304d\u51fa\u3059 - potisan\u306e\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}