Split dataset records into half

[Khaled_Eid]

hi

how can split the dataset records into half and load it in two different destination (without use the total number of records)

[ShankerV · Accepted solution]

Hi @Khaled_Eid 

One way to do is with the Sample tool.

Input contains 8 records. 

Note: Using the output tool, you can save the output to new destination.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Khaled_Eid 

When the input contains 14 records in input, below is the output.

Many thanks

Shanker V

[RobertZiegl · Accepted solution]

I would create a row id per row and then use the mod function to split the file into 2 halfs and then output the data to two destinations (you can add the prefix/suffix to the output table)

 

[Khaled_Eid]

Okay but how can i get The Second half into another output 

[ShankerV · Accepted solution]

Hi @Khaled_Eid 

The below highlighted will help you to get the second half.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Khaled_Eid 

Step 1: Input

Step 2: 

Step 3:

Step 4:

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Khaled_Eid 

If in need, the second half should be in same order as input. Then add these 2 tools in additional.

Additional steps if in need, 

Additional steps if in need, 

Many thanks

Shanker V