In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Messy Data Cleaning

AvinashBhawsar
8 - Asteroid

Hi, I have been trying to clean the data however, I could not get this. can anyone help how to do it?

It has two sheets "Dirty" and "Clean". Clean sheet is an expected output.

 

4 REPLIES 4
griffinwelsh
12 - Quasar

This will work at least for the structure provided

binuacs
21 - Polaris

@AvinashBhawsar batch macro approach

image.png

LindonB
11 - Bolide

Certainly a number of data prep steps needed here. I approach this by first using the first three rows to derive field names for the other rows. Then combined and cleaned. Let me know if you have any questions.

AvinashBhawsar
8 - Asteroid

Thank you!

apologies for late response

Labels
Top Solution Authors