You can use Table.ColumnNames(MyTable){n}
to return a column name by its position - this this is base 0, so the 6th column name would be Table.ColumnNames(MyTable){5}
You can then use Record.Field
to reference a column by its name.
You can also filter by a list, rather than stringing criteria together with the or
operator.
So, putting this together for your example:
#"Filtered Part Desc" = Table.SelectRows (
#"Removed Columns3",
each List.Contains(
{"ENG","TRANS"},
Record.Field(_, Table.ColumnNames(#"Removed Columns3"){5})
)
)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…