community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to transform this data

Asteroid

Hi All,

 

We have a scenario wherein we have few rows that needs to be transformed as columns. Please find attached screenshot. In this, we have Region, Sector, Filter, Metric Filter, Population and Brand as rows and below that we have data as column. We need to make all these as columns with date. 

 

Also, like this we have around 10-12 sheets with same structure. 

 

Could you please help us on this?

 

I have attached both input and output file screenshot.

 

Thanks,

Amit Belagali

Alteryx Certified Partner

hey @AmitBelagali

 

There are no screens attached.

 

But have you looked into the crosstab tool?

Asteroid

Hi @LordNeilLord,

 

Tried that Neil. But in vain. Could you please suggest us a different way?

Alteryx Certified Partner

Ewww, that looks like one messy spreadsheet!

 

Without an actual example of the data it's going to be hard to give you a full solution...but looking at it from the pics...this is probably going to need some muli-row formula tools and a few transposes first.

 

Can you attach an example of the actual data (or that mock up you just screen shotted)?

Asteroid

Hi @LordNeilLord,

 

Please find attached mockup data.

 

Thanks for your help.

 

Thanks,

Amit Belagali

Alteryx Certified Partner

Hey @AmitBelagali

 

Have you tried to import your mockup into Alteryx?

 

I can only get to import the first 8 rows

Asteroid

Hi @LordNeilLord,

 

I have tried loading the file. The file loads fine. In the Preview only first 8 rows are loaded don't know the reason why. But i am able to load the file.

 

Thanks,

Amit Belagali

Alteryx Certified Partner

Hey, yeah I got it loaded

Asteroid

Awesome. Could you please me with further steps?

Highlighted
Alteryx Certified Partner

Hey @AmitBelagali

 

Sorry for the delay

 

I've attached an example of how to approach one of the sections, mostly reliant on Multi-Row formula. Use this to get you started and see if you can figure out the rest :)

 

 

Labels