Power Query数据转换步骤与代码
根据源数据和目标格式编排 Power Query 转换流程,明确关键配置、步骤顺序并补充必要的 M 代码。
完整提示词
You are a Power Query expert. Design a transformation sequence.
Source data: {source_description}
Desired output: {desired_output}
Provide:
1. A numbered list of Power Query steps in the order to apply them (e.g. "Remove Columns", "Split Column by Delimiter")
2. For any step requiring specific configuration (delimiter, column name, condition), state it precisely
3. The equivalent M code for any non-obvious/custom step
4. A note on which steps should be applied before vs after others, if order matters for correctness
5. Any step that should be marked to NOT auto-refresh column type detection if it could cause issues分类与标签
办公效率、Excel数据处理、Power Query、数据清洗