Keep only active employees on a roster

Three steps

1. 1

   Upload a sheet with status

   Drop the roster at https://dianwu.ai and confirm a status / active column.

2. 2

   Say “active only”

   Ask for active employees only, then Instant convert. Left-company rows should drop out of the preview.

3. 3

   Check row count, then save if monthly

   Verify headcount. Save as a workflow for recurring reports; Instant convert for ad-hoc counts. Pricing: https://dianwu.ai/pricing.

Matching status values

Name the value as it appears in the sheet (在职, Active, etc.). Fix header drift in full-screen edit before filtering.

After filtering you can still group by department or mask PII. Metered by instant conversions.

With grouping and onboarding

Chain department grouping after the filter, or keep onboarding checklist as its own saved workflow.

Onboarding one table: https://dianwu.ai/en/faq/hr-onboarding-one-table.