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

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Transposing human sheet

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

 

Highlighted
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