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

Alteryx designer Discussions

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

Transposing human sheet

Highlighted
Meteor

Hello,

 

I'm trying to transpose this sheet to get a format that fits for better graphics and so on.

 

But the date is on top of 6 columns of data, and I also want to use columns "Produto" and "Base", as the main reference, and I can reject the first 3 columns of this data...

 

Follow attached a sample of the sheet. Of course i have tons more days of data...

 

I've tried a workflow that also follows attached.. but it didnt worked .. :(

 

Anyone can help?

 

Best Regards,

 

Tanai

Bolide

Hi @Tanai, is this more along the lines of what you're looking for?

Meteor

@JoBen  This is very cool. Thanks for the help!

 

But I would have to put the last column number on the dynamic select tool?

 

What if this is moving?

 

Best regards,

 

Tanai

 

Bolide

Hi @Tanai, I've reconfigured the workflow to hopefully handle moving columns. Let me know what you think. Thanks!

Meteor

Hey @JoBen, thanks again for the help.

 

But I'm still not matching the results.. 

 

But i'l work on it.

 

Thanks for the reply.

 

Regards,

 

Tanai

Bolide

Okay. Good luck! 

Labels