Week 1 · D1🔒 LockedAbout 1 hours
AI Table Cleanup: Find Duplicates Without Losing Records
Use fictional order lines to identify duplicate candidates, missing values and conflicts, then compare retained row counts and amounts after human review.
Use fictional order lines to identify duplicate candidates, missing values and conflicts, then compare retained row counts and amounts after human review.
Interview questions
Why should AI not automatically delete an order line when order ID, item, quantity and amount all match another row?两条订单明细的订单号、商品、数量和金额完全相同,为什么仍不能让 AI 自动删除一条?
Common in ChinaCommon overseasBasic#everyday-ai#spreadsheet#review🔒 Unlock this chapter to see the answer keys.
How should you handle different items under one order ID, a missing ID, or different amounts under the same ID?同一订单号出现不同商品、订单号缺失,或同一订单号的金额不同,应该怎样处理?
Common in ChinaCommon overseasBasic#everyday-ai#spreadsheet#data🔒 Unlock this chapter to see the answer keys.
The scenario assumes an owner confirmed only R02 as a repeated import. How do you reconcile the hypothetical exclusion and pending scope?题设假定负责人只确认 R02 是重复导入,模拟排除后如何核对行数、金额和待查范围?
Common in ChinaCommon overseasBasic#everyday-ai#spreadsheet#review🔒 Unlock this chapter to see the answer keys.
