Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

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

How to arrange a sheet like this? I think it is simple but i just can not figure out

Krasus
8 - Asteroid

Hello, 

 

I have a simple question about the arrange tool, may i use it to arrange my table from like this:

 

Before:

DatesABC
2016-01-011611
2016-01-042712
2016-01-053813
2016-01-064914
2016-01-0751015

 

After:

DatesNameValue
2016-01-01A1
2016-01-04A2
2016-01-05A3
2016-01-06A4
2016-01-07A5
2016-01-01B6
2016-01-04B7
2016-01-05B8
2016-01-06B9
2016-01-07B10
2016-01-01C11
2016-01-04C12
2016-01-05C13
2016-01-06C14
2016-01-07C15

 

I attache an example in Excel, maybe anyone can help me to etablish a workflow Alteryx?

 

Thanks a lot!

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

Use a transpose tool (http://downloads.alteryx.com/Alteryx/Help/Transpose.htm).

 

With Key field set to Date

Krasus
8 - Asteroid

It's really bralliant!!!!!! Thank you very much

Labels