Filter or Formular

[Emma_c_857]

Hello. Is there a function can help me get to the result I want:

The original table

A-BC	-1000
D, EF	-90
GHI	0
J(K)L	70
M N O	888
PQR.	0

Result:

two separated table: One table for amount >0 and now table for amount<0.

I tried using two filters: first filter- filter out 0; second filter  - filter >0: this gets me two results: if True, >0; if false, 

[VictorLeonis · Accepted solution]

Hey @Emma_c_857 ....

Let me try to understand what you need.
Do you need to split the original table into 2?  One with amount > 0 and other one < 0?

If you just need to split the original table you should use a filter, the formula is not able to remove records in the flow, just change or create columns/values.

[CharlieS · Accepted solution]

Hi @Emma_c_857 

So you want to remove records of 0 and then split the remaining data into two tables. Then like you mentioned, I would suggest two Filter tools. 

In the attached example, I assign the field names of [Field1] and [Field2] and use two Filter tools to create the two datasets requirested. Check it out and let me know if this helps. 

[Emma_c_857]

Thank you! i understand it now.