In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Split Data from Column to Multiple Columns

ArijitRoy
8 - Asteroid

Hello Friends,

 

I have attached a sample file. In the first column, I have data on 30 rows. I want to divide them into 3 columns, which means 10 rows for each column.

 

It should be dynamic as I have more than 1M data on the first column and want to divide them and each column should have 9000 rows. 

 

Every column should have only 9000 rows data.

7 REPLIES 7
Luke_C
17 - Castor
17 - Castor

Hi @ArijitRoy 

 

Have you looked at the make columns tool? It lets you enter how many columns you want. It is limited at 1000 columns, though. image.png

ArijitRoy
8 - Asteroid

Hi @Luke_C,

 

This is a great tool but not dynamic. I want to fix per column data to 9000 rows.

Luke_C
17 - Castor
17 - Castor

Hi @ArijitRoy 

 

Here's a bit more dynamic. Update the first multi-row formula from 10 to 9000 and you should be good to go.

 

image.png

ArijitRoy
8 - Asteroid

Hi @Luke_C ,

 

Just look at the last column. Why we have blanks in middle of the rows? Last column should not have any blanks in middle.

ArijitRoy
8 - Asteroid

Thanks @Luke_C for the tool. I have used sort tool on the Counter column.

binuacs
21 - Polaris
Luke_C
17 - Castor
17 - Castor

Hi @ArijitRoy In my example there is a null because you only provided 29 rows of actual data (30 including header). 

Labels
Top Solution Authors