Transform hub
Browse tools for transform tasks.
Hub intro and use cases
This hub groups tools that focus on transform operations.
- Start with transform tools and then continue to the next workflow hub.
On this page
Jump to each section quickly.
Workflows in this hub
Touching = workflows with at least one transform tool. Primary = first step is transform or most steps are transform.
Extract Columns and Convert to JSON
Pull only the columns you need from a CSV, then convert the slimmed-down data to JSON.
Use case
Use this when a wide CSV contains many columns but only a subset are relevant, and you want lean JSON for an API, script, or frontend component.
Slim CSV and Deduplicate
Remove unwanted columns, deduplicate rows, then validate the final CSV.
Use case
Use this before sharing a CSV with external parties when you need to strip private or irrelevant columns and ensure no duplicate records are included.
Validate CSV then CSV Formula Applier
Validate raw CSV first, then run CSV Formula Applier for a safe, repeatable pipeline.
Use case
Use this when incoming CSV quality is uncertain and you want a validation gate before running CSV Formula Applier.
Clean CSV then CSV Formula Applier
Normalize CSV structure before running CSV Formula Applier to reduce downstream surprises.
Use case
Use this when exports have inconsistent spacing/quoting and you want better results from CSV Formula Applier.
Extract Columns then Validate CSV
Keep only required columns first, then validate the reduced dataset for safe handoff.
Use case
Use this when exports contain many fields and you want a minimal validated CSV with only the required columns.
Remove PII Columns and Validate CSV
Strip sensitive columns before validating final CSV shape for safe sharing.
Use case
Use this before sharing operational exports externally where personal data must be removed and structure must still validate.
CSV Column Extractor Output Sanity Check
Run CSV Column Extractor and immediately inspect the resulting payload format to verify the output is ready for the next handoff.
Use case
Use this when you want a quick confidence check that csv column extractor produces the kind of payload you expect before wiring it into larger workflows or sharing results.
CSV Column Remover Output Sanity Check
Run CSV Column Remover and immediately inspect the resulting payload format to verify the output is ready for the next handoff.
Use case
Use this when you want a quick confidence check that csv column remover produces the kind of payload you expect before wiring it into larger workflows or sharing results.
CSV Formula Applier Output Sanity Check
Run CSV Formula Applier and immediately inspect the resulting payload format to verify the output is ready for the next handoff.
Use case
Use this when you want a quick confidence check that csv formula applier produces the kind of payload you expect before wiring it into larger workflows or sharing results.
CSV Formula Applier: Quality Gate
Run CSV Formula Applier in a guardrailed pipeline that validates and prepares data for downstream consumption.
Use case
Use this when csv formula applier is part of a repeatable process and you want a quality check before/after the core transformation.
CSV Formula Applier: Delivery Flow
Use CSV Formula Applier as a middle step, then shape output for delivery to APIs, reports, or handoff files.
Use case
Use this when you need csv formula applier plus a final delivery-oriented output format.
Transform CSV Columns
Apply per-column transformation rules to normalize and standardize CSV data.
Use case
Use this when spreadsheet exports need cleaning like trimming, case conversion, or date formatting before analysis.
Transform CSV and Validate
Transform CSV rows with rules, then validate the cleaned output.
Use case
Use this to ensure transformation rules produce valid CSV that can be safely loaded into databases or APIs.
Transform CSV Then Convert to JSON
Apply transformation rules to CSV, then convert the result to JSON.
Use case
Use this when you need both column normalization and JSON output for downstream API ingestion.
Pivot CSV for Reporting
Create a cross-tabulation of CSV data with aggregated metrics.
Use case
Use this to reshape flat CSV data into summary reports with rows, columns, and calculated aggregates.
Pivot CSV and Validate
Create a pivot table from CSV data, then validate the output.
Use case
Use this to verify pivot results contain valid CSV structure before loading into analytical tools.
Pivot CSV Then Analyze
Create a pivot table from CSV, then profile the output columns.
Use case
Use this to generate summary tables and immediately inspect column characteristics.
Map JSON Array Fields
Project and rename fields from JSON arrays to match target schema.
Use case
Use this to select specific columns and rename fields for API contract compliance.
Map JSON Array Then Convert to CSV
Select and rename JSON array fields, then convert to CSV.
Use case
Use this to export specific JSON fields as a spreadsheet for downstream analysis.
Map JSON Array Then Validate
Project JSON array fields, then validate the result.
Use case
Use this to ensure field projection maintains valid JSON structure for next steps.
Group JSON Array for Reporting
Group JSON array records by a field to create summary views.
Use case
Use this to organize flat JSON records by category or dimension for reporting dashboards.
Group JSON Array Then Convert to CSV
Group JSON records by field, then convert to CSV for export.
Use case
Use this to summarize grouped data and output as spreadsheet format.
Group JSON Array and Validate
Group JSON records by field, then validate the grouping result.
Use case
Use this to ensure grouping logic produces valid JSON structure.
Filter YAML Records
Filter YAML array records by field conditions.
Use case
Use this to subset YAML data before processing, like selecting active records or specific regions.
Filter YAML Records Then Convert to JSON
Filter YAML array records, then convert result to JSON.
Use case
Use this to extract subset of YAML data and output as structured JSON for APIs.
Filter YAML Records and Validate
Filter YAML array records, then validate the filtered output.
Use case
Use this to ensure filter conditions work correctly before downstream processing.
Transform XML Attributes to Elements
Convert XML attributes to child elements for normalization.
Use case
Use this to standardize XML structure by converting attribute-based notation to element-based.
Transform XML Attributes Then Convert to JSON
Normalize XML by converting attributes to elements, then output as JSON.
Use case
Use this to restructure XML and export as JSON for API consumption.
Transform XML Attributes and Validate
Transform XML structure, then validate the result.
Use case
Use this to ensure attribute-to-element conversion produces valid XML.
Extract Columns and Heatmap
Extract target columns and render them as a heatmap table.
Use case
Use this to focus on key metrics and quickly inspect relative intensity patterns.