Need to split data based on Row value

I have input consisting of column named "Record ID, Field_1 and Result". Now in the result column I have "True and false" one time, another time I have "only false". Now my constrain is "If the result column contains both "True and False" I need all the row contents that are above "True". Whereas if the result column contains only "False" i need all the row contents irrespective of true or false. Can anyone please help to find a solution for this.

Sampe Input.xlsx

Common Use Cases

Dynamic Processing

Accepted answers

grazitti_sapna

Hi @Gsiva3 , now the workflow will return the 9 rows above 10 th row where the result is true and the rows after 10th row will fall under false condition.

Is this what you are looking for?

Thanks.

Split-Data-GS_v1.yxmd

Qiu

@Gsiva3
It seems that I have mis-interpretated you intention.

I made it dynamic so only ont output is present.

Revised my workflow, kindly check.

1012-Gsiva3.yxzp

All comments

Qiu

@Gsiva3
I hope this is what you want. if you like accept it as the solution. Thanks.

1012-Gsiva3.yxzp

grazitti_sapna

Hi @Gsiva3 , you can use filter tool for this apply filter on result and you will get the desired value.

In my case I have used Result is true therefore 1 record in true anchor and rest in false anchor along with the row data.

Thanks.

Split-Data-GS.yxmd

Gsiva3

Hi @Grazitti,

Thanks for the solution. But the thing is, when I have true in the result column, I need rows that are above "True". For example: if "row number 10" has true then I need rows above row number 10. Please help me with this.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703