在PowerBI M-language中,我需要为多个文件中的每个表列删除一个特定的列号(编号5)。到目前为止,我已经成功地通过名称删除了列,但是列5的命名变化,我想通过它的columnnumber而不是它的columnname来删除列。
= Table.RemoveColumns(
Table.PromoteHeaders(Csv.Document([Content], [Delimiter = ";", Columns = 11, Encoding = 1252])),
"ColumnName"
)
Thanks in advance
= Table.RemoveColumns(x,Table.ColumnNames(x){4})
那么可能
= Table.RemoveColumns(
Table.PromoteHeaders(Csv.Document([Content], [Delimiter = ";", Columns = 11, Encoding = 1252]))
, Table.ColumnNames(Table.PromoteHeaders(Csv.Document([Content], [Delimiter = ";", Columns = 11, Encoding = 1252]))){4}
)