Clarification of "Workload before Input"

Becky

I believe not a few people start analysis from bad condition format like sample file....

①Data zone don't start from ColumnA!

②Data zone don't start from Row1 !

③Table head is not single row and include Grouping...

④data is divided for separated sheet

Now I spend A LOT OF TIME to make them to DB format.

I want to clarify is there some Alteryx function to solve avobe problems?

Now I think Alteryx is mainly for after this format revise phase, is it right understanding???

It is very greatefule is someone help me.

【forAlteryx】Workload before Input.xlsx

JordanB

Hi @Becky

This was an interesting use case. Alteryx can be used for this and I think I have been able to get to a workable solution that should be dynamic as more dates get added to your files. 

Please take a look as I have included descriptions within the module.

Best,

Jordan Barker

Solutions Consultant

Workflow before Input Sample.yxzp