Transposing Data

PPNU

I have an excel template for various regions. I want to read it through Alteryx and store the data in database.

I'm new to Alteryx, so I feel difficulty how can a new columns would be created for region and last date updated from the data in template.

Secondly, I want data store in columnar structure , means category which is in row in excel would be in column against which data would be populated for the category to make it easy for filter data on category level.

Please find sample data attached here. 

Can somebody recommend something

 Thanks in advance

sample.xlsx

OllieClarke

Hi @PPNU 

That wasn't the most straightforward challenge, but here's a workflow that does what you want (I think):

as well as Cross-Tabs and Transpose tools, I also needed a multi-row formula tool and some Joins (along with an append field). 

I'd recommend checking out the learning resources available on the community Learning Paths, Interactive Lessons and Weekly Challenges as well as the documentation/example workflows of the tools in Designer itself. Between those resources you should be flying in no time. 

Hope that helps,

Ollie

PPNU.yxzp

PPNU.yxmd