Data rarely arrives in the shape you need — CSV exports from spreadsheets, YAML configs from DevOps, duplicate lines from log merges, or numbers in hex when you expected decimal. WoDeTool's Data Processing scenario covers format conversion, deduplication, and radix conversion without spinning up Python one-liners for every small task.
Format conversion pipeline
JSON ↔ CSV helps when product managers send spreadsheet exports but your pipeline expects JSON arrays. Paste or upload, map columns, and copy JSON for scripts or API imports.
JSON ↔ YAML supports editing Kubernetes manifests or docker-compose snippets — convert to JSON for strict validation, then back to YAML for readability.
Chain conversions on WoDeTool: CSV → JSON → format → diff against a golden file when regression-testing ETL scripts.
Cleaning and normalizing data
Text Dedup removes duplicate lines from merged log files, survey exports, or email lists — choose whether to keep first or last occurrence.
Number Base Converter translates between binary, octal, decimal, and hexadecimal — handy when reading hardware registers, color values, or bitmask documentation.
Tips for reliable conversions
Always spot-check row counts after CSV conversion — empty trailing columns often create unexpected null fields.
For YAML, watch indentation-sensitive blocks; a quick JSON round-trip through the formatter catches many structural issues.
Save frequent conversion sequences as WoDeTool pipelines to repeat weekly reporting tasks in one click.
ETL-style pipeline on WoDeTool
CSV → JSON → JSON Formatter → JSON Diff against a golden file catches schema regressions before deploy. Configure once on the Pipeline page and re-run after every export.
Read WoDeTool Pipelines: Turn Repetitive Steps into One-Click Workflows for webhook and pre-release validation examples.