We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Split line item between the rows

Maheshp
8 - Asteroid

Hi Team,

 

I have the records with 1000-line items, but I want to split them between 500-500 in separate file.

 

could you please help me on this. 

 

Maheshp_0-1674108909051.png

Regards,

 

Mahesh

 

4 REPLIES 4
ShankerV
17 - Castor

Hi @Maheshp 

 

This can be achieved with the help of Record ID tool and Filter tool.

 

 

ShankerV
17 - Castor

Hi @Maheshp 

 

Please find the below workflow which will help to reach your solution.

 

ShankerV_0-1674109119221.png

 

ShankerV
17 - Castor

Hi @Maheshp 

 

Step 1: Input

ShankerV_0-1674109160906.png

 

Step 2: 

ShankerV_1-1674109174808.pngShankerV_2-1674109182517.png

 

Step 3:

 

ShankerV_3-1674109201057.png

 

ShankerV_4-1674109211711.png

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @Maheshp 

 

++One more information.

If you don't want to have the record id displayed in the output.

 

Use the Select tool to Unselect the Record ID.

 

ShankerV_1-1674109380618.png

 

ShankerV_0-1674109366185.png

 

Labels
Top Solution Authors