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