功率查询 - 格式 - 添加中间的“摘要”文字行

发布于 2025-01-27 02:57:05 字数 1103 浏览 1 评论 0原文

我正在从数据库中转换一些数据，在其中一个步骤的末尾，我需要将其重新格式化以将其作为文档发送给客户。该文档的通常模板具有中间行，其中一列的摘要（只是文本，没有数字）。这意味着从第一个到第二个桌子下面。是否可以？

值1	值元数据1	值的元数据2	分组
第一	M1	1st M2	组1
第二个	M1 2nd M1	2nd M2	Group
第四	2第三M1 3rd M1	3rd M2	Group 3
fort	M1 4th M1	4th M2组4th M2	组值1

值1值1	值Metadata1	值的Metadata 2
Group 2 Group 1
1ST M2 M2 M2 M2 M2 M2 M2 M2 M2 M2 M2	1st M1	M2 M2 M2 M2 M2 M2 M2 m2
第四	第四M1	4th M2
Group2
第二个	M1	2nd M2
组3
第三	三分M1	3rd M2

原文

I am transforming some data from a database, and at the end of one of the step, I need to reformat it for sending it as a document to a client. the usual template for this document has intermediate row with a sort of summary of one of the column (just text, no numbers). It would means going from first to second table here under.
Is it possible ?

value 1	value metadata1	value's metadata 2	grouping
First	1st M1	1st M2	group 1
Second	2nd M1	2nd M2	group 2
Third	3rd M1	3rd M2	group 3
Fourth	4th M1	4th M2	group 1

value 1	value metadata1	value's metadata 2
group 1
First	1st M1	1st M2
Fourth	4th M1	4th M2
group2
Second	2nd M1	2nd M2
group 3
Third	3rd M1	3rd M2

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

等风来 2025-02-03 02:57:05

在PowerQuery中，在分组上尝试以下

IT组，然后将其复制为 value 1 列中的新行，然后扩展

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"grouping"}, {{"data", each #table( {"value 1"}, {{_[grouping]{0}}}) & _, type table }}),
ColumnsToExpand = List.RemoveLastN(List.Distinct(List.Combine(List.Transform(Table.Column(#"Grouped Rows", "data"), each if _ is table then Table.ColumnNames(_) else {}))),1),
#"Expanded data" = Table.ExpandTableColumn(#"Grouped Rows", "data",ColumnsToExpand ,ColumnsToExpand ),
#"Removed Columns" = Table.RemoveColumns(#"Expanded data",{"grouping"})
in  #"Removed Columns"

In powerquery, try below

It groups on grouping and copies that into a new row in value 1 column before expanding

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"grouping"}, {{"data", each #table( {"value 1"}, {{_[grouping]{0}}}) & _, type table }}),
ColumnsToExpand = List.RemoveLastN(List.Distinct(List.Combine(List.Transform(Table.Column(#"Grouped Rows", "data"), each if _ is table then Table.ColumnNames(_) else {}))),1),
#"Expanded data" = Table.ExpandTableColumn(#"Grouped Rows", "data",ColumnsToExpand ,ColumnsToExpand ),
#"Removed Columns" = Table.RemoveColumns(#"Expanded data",{"grouping"})
in  #"Removed Columns"