Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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