Data Arranging and formatting

Dear all,

I hope that you can help me in this a challenged part of the project that I want to make.

I have attached two excel files Input and Output. What I want is to make a workflow using Alteryx to input the input file that the attached one and the result of this input after designing the workflow the output should be the same of the attached file (Output file). So, any help in that please?

Workflow

Transformation

Udacity

Accepted answers

Since I thought you would need a automatic way of removing the title name separated by 2 rows, I have created a way of renaming your column names.

Take a look at the attached example and let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-09 Data Arranging and formatting.yxmd

All comments

Would you be able to code color your files only to understand where some column names are coming from? For instance, the below columns.

Thank you,

Fernando Vizcaino

These columns are additional columns with empty cells just to be added without any data from input file.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703