प्रशिक्षण
मॉड्यूल
تحويل البيانات من خلال تنفيذ العرض المحوري، غير المحوري والقيمة المحتسبة والمكعب - 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
يشكل هذا المحتوى جزءا من تحويل البيانات من خلال تنفيذ العرض المحوري وإلغاء العرض المحوري واالتقاط والتكبير والمكعب.