Separating Column Values on Percentage Basis

P2017000971

Hello to every one,

thanks For Taking the Time to look into my Question

I will Explain the issue using some examples for better clarification

NO Product Price

1 593

2 623

3 1880

4 2811

5 1208

6 3403

7 2300

8 2406

9 2729

10 2500

Let us Assume we have the Previous Two Columns (i.e. NO and Product Price)

I want to separate their values based on 50% basis of overall values in column

in this Example we have 10 values so the aim is to make it like this :

First Output 

NO Product Price

1 593

2 623

3 1880

4 2811

5 1208

Second Output 

NO Product Price

6 3403

7 2300

8 2406

9 2729

10 2500

If there is way to generate two different outputs, it is good

Also if there was a way to select a portion depending on my preference that is even better.

lionelderkrikor

Hi @P2017000971,

Here a process (in attached file) that performs what you want to do (based on your example)

Regards,

Lionel

Telcontar120

You can do this pretty easily with Filter Example Range as well, if you know in advance how many records there are and how many you want in each partition.