Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Rows to Columns

rgarcia2
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 

8 REPLIES 8
Bennel_Wilson
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.

 

deviseetharaman
11 - Bolide

Hi,

 

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

RobertOdera
13 - Pulsar

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!

rgarcia2
5 - Atom

Thanks mate, this worked flawlessly

Bennel_Wilson
8 - Asteroid

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

Bennel_Wilson
8 - Asteroid

Hi @RobertOdera ,

Liked this approach as well. Thanks for sharing.

RobertOdera
13 - Pulsar

Sure @Bennel_Wilson 

My pleasure!

brwright
8 - Asteroid

Simple and highly effective! 

Labels