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