Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

Rows to Columns

5 - Atom

hello 

i need to turn some rows into columns for example my data looks like this

rgarcia2_0-1589691916439.png

 

I need 

BFC05/16/20204.436913267130131.0
BFC05/16/20204.4371138   
         
         

 

 

So basically all the dates stay in one column, anything within the dates get turned into columns 

Highlighted
8 - Asteroid

Hi,

I made an attempt to solve your query. Let me know if this works for you.

 

Input:

Bennel_Wilson_0-1589706587779.png

 

Output:

Bennel_Wilson_2-1589707374007.png

 

So,

As I did not know the maximum rows of value for each date, I had input a standard 10 columns in the Text to columns Tools.(You'll see that in the attached workflow)

 

Regards

Benn

 

P.S: In case this works for you, kindly mark it as a solution.

 

Highlighted
11 - Bolide

Hi,

 

Please check if this solution works for you.Alteryx Calculation.png

Highlighted
12 - Quasar

Hi, @rgarcia2 

 

Here's how I would handle it fully automated (Columns will be auto-generated versus manually entering a parameter in Parsing Tools or manual explicit formulas in Multi-row Tool).

 

Please mark as an acceptable solution and LIKE, if this works for you.

 

Solution Output

RNO2_0-1589729563733.png

Workflow

RNO2_1-1589729589460.png

Please see the attached flow.

Good Luck!

Highlighted
5 - Atom

Thanks mate, this worked flawlessly

Highlighted
8 - Asteroid

Glad, I could help. It was a nice piece of learning for me as well.

Highlighted
8 - Asteroid

Hi @RobertOdera ,

Liked this approach as well. Thanks for sharing.

Highlighted
12 - Quasar

Sure @Bennel_Wilson 

My pleasure!

Labels