Help Needed with Automating Data Cleansing Workflow - Emmanuel Katto Uganda

[emmanuelkatto]

Hi Everyone, I am Emmanuel Katto. I'm seeking some guidance on automating a data cleansing workflow. I want to create an automated workflow that cleanses a dataset by performing the following steps:

Data Import: Import data from multiple Excel files.
Data Cleaning: Standardize column names, remove duplicates, and fill missing values.
Data Transformation: Apply specific transformations like date formatting and text manipulation.
Data Export: Export the cleaned and transformed data to a single CSV file.

I'm struggling with more complex cleansing steps, like filling missing values based on conditions and want to know how to schedule this workflow to run automatically on a daily basis.

Please help!!

Thanks!

Emmanuel Katto

[griffinwelsh]

It would be helpful if you provided some sample data. There are multiple possible approaches depending on your data structure. As for scheduling automatically you will want to look into Alteryx server.

How to schedule a workflow with Alteryx Server: https://help.alteryx.com/current/en/server/use-alteryx-server-ui/schedules--server-user-interface/sc...