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.

[JordanB · Accepted solution]

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

[Becky]

Ohhhhh! That's amazing for me!

Now I confirming detail process you provide me but I'm sure result is what I wanted.

It's really big paradigm shift for me that Alteryx can be used for data shaping process before input!

We usually use excel VBA or other programing for it......

Thank you very much!