top of page
Workflow Automation Templates
A library of ready-to-use workflow templates to accelerate your data journey
Excel Data Cleansing
Read and cleanse Excel data
Overview
This workflow demonstrates how to import data from an Excel file using the Read Excel Advanced node and cleanse the data using the Data Cleansing Advanced node to improve data quality.
Details
The workflow reads data from an Excel file using the Read Excel Advanced node. It then cleanses and standardizes the dataset by removing null and blank values using the Data Cleansing Advanced node. Finally, the Print N Rows node is used to preview a selected number of rows from the cleaned output.
bottom of page