التدريب
الوحدة النمطية
تحويل البيانات من خلال تنفيذ العرض المحوري، غير المحوري والقيمة المحتسبة والمكعب - Training
يشكل هذا المحتوى جزءا من تحويل البيانات من خلال تنفيذ العرض المحوري وإلغاء العرض المحوري واالتقاط والتكبير والمكعب.
لم يعد هذا المتصفح مدعومًا.
بادر بالترقية إلى Microsoft Edge للاستفادة من أحدث الميزات والتحديثات الأمنية والدعم الفني.
Table.Pivot(table as table, pivotValues as list, attributeColumn as text, valueColumn as text, optional aggregationFunction as nullable function) as table
Given a pair of columns representing attribute-value pairs, rotates the data in the attribute column into a column headings.
Take the values "a", "b", and "c" in the attribute column of table ({ [ key = "x", attribute = "a", value = 1 ], [ key = "x", attribute = "c", value = 3 ], [ key = "y", attribute = "a", value = 2 ], [ key = "y", attribute = "b", value = 4 ] })
and pivot them into their own column.
Usage
Table.Pivot(
Table.FromRecords({
[key = "x", attribute = "a", value = 1],
[key = "x", attribute = "c", value = 3],
[key = "y", attribute = "a", value = 2],
[key = "y", attribute = "b", value = 4]
}),
{"a", "b", "c"},
"attribute",
"value"
)
Output
Table.FromRecords({
[key = "x", a = 1, b = null, c = 3],
[key = "y", a = 2, b = 4, c = null]
})
Take the values "a", "b", and "c" in the attribute column of table ({ [ key = "x", attribute = "a", value = 1 ], [ key = "x", attribute = "c", value = 3 ], [ key = "x", attribute = "c", value = 5 ], [ key = "y", attribute = "a", value = 2 ], [ key = "y", attribute = "b", value = 4 ] })
and pivot them into their own column. The attribute "c" for key "x" has multiple values associated with it, so use the function List.Max to resolve the conflict.
Usage
Table.Pivot(
Table.FromRecords({
[key = "x", attribute = "a", value = 1],
[key = "x", attribute = "c", value = 3],
[key = "x", attribute = "c", value = 5],
[key = "y", attribute = "a", value = 2],
[key = "y", attribute = "b", value = 4]
}),
{"a", "b", "c"},
"attribute",
"value",
List.Max
)
Output
Table.FromRecords({
[key = "x", a = 1, b = null, c = 5],
[key = "y", a = 2, b = 4, c = null]
})
التدريب
الوحدة النمطية
تحويل البيانات من خلال تنفيذ العرض المحوري، غير المحوري والقيمة المحتسبة والمكعب - Training
يشكل هذا المحتوى جزءا من تحويل البيانات من خلال تنفيذ العرض المحوري وإلغاء العرض المحوري واالتقاط والتكبير والمكعب.