多表合并Merge multiple tables
输出合并表与冲突日志;冲突不静默覆盖。
Output a merged table and conflict log; conflicts are not silently overwritten.
提示词效果未实测。Prompt effect has not been tested.
提示词是可复跑的模板,不是效果承诺。换模型、换版本、换输入都可能改变结果;用本页的检查点自己核对,并把官方出处当作机制依据而不是效果保证。A prompt is a re-runnable template, not a promise of results. Changing the model, version or input can change the outcome. Use the checkpoints on this page to verify it yourself, and treat the official sources as evidence of mechanism rather than a guarantee of effect.
任务与输入Task and inputs
按规则合并多表并记录冲突。 输入:多个表格、主键、合并规则、优先级。
Output a merged table and conflict log; conflicts are not silently overwritten. Inputs: Multiple tables, key fields, merge rules, and priority.
提示词本体The prompt
按主键 {key} 合并表格。规则:{rules}。输出 merged[] 与 conflicts[]。同主键字段不一致时保留所有候选值并在 conflicts 写来源表与字段;不得按优先级静默覆盖,除非规则明确授权。
占位符用 {字段} 标注,运行前替换为本次输入。
Merge tables on {key}. Rules: {rules}. Output merged[] and conflicts[]. When same-key fields disagree, keep all candidate values and record source table and field in conflicts; do not silently overwrite by priority unless the rules explicitly authorise it.
Replace {field} placeholders with the current inputs before running.
预期输出形态Expected output shape
merged[] 与 conflicts[],冲突含来源与候选值。
merged[] and conflicts[] with sources and candidate values.
检查点Checkpoints
- 主键唯一或冲突已记录。
- 每个覆盖都有规则授权。
- 行数等于输入主键并集。
- Keys are unique or conflicts recorded.
- Every overwrite has rule authorisation.
- Row count equals the union of input keys.
失败分支Failure branches
- 主键选错:先核对字段含义。
- 冲突过多:人工定规则后再跑。
- Wrong key: check field meanings first.
- Too many conflicts: define rules manually before rerunning.
出处与边界Sources and limits
提示词效果未实测。机制依据见出处;换模型、版本或输入会改变结果。
This site has not tested the effect of this prompt. See the sources for the mechanism; changing model, version or input can change the result.
出处Sources
| 来源Source | 链接URL |
|---|---|
| OpenAI Cookbook · Introduction to Structured Outputs(官方仓库 raw,2026-11-07 直抓 200)OpenAI Cookbook: Introduction to Structured Outputs (official repository raw, fetched 200 on 2026-11-07) | https://raw.githubusercontent.com/openai/openai-cookbook/main/examples/Structured_Outputs_Intro.ipynbhttps://raw.githubusercontent.com/openai/openai-cookbook/main/examples/Structured_Outputs_Intro.ipynb |
资料快照日期:2026-11-07;单项复核范围与日期见对应正文或来源记录。产品功能与条款可能变化,使用前请核对原始来源。Source snapshot: 2026-11-07; item-specific rechecks and their scope are recorded in the text or source notes. Features and terms may change; check the original sources before use.