Filter or Formular

Question

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

The original table

A-BC-1000

D, EF-90GHI0J(K)L70M N O888PQR.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 Answer

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 Answer

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.