Hi, what tool should I use if I want to make sure debit and credit side are the same before generating output?
Solved! Go to Solution.
Hi @wenyg,
It highly depends on the structure of your data, but I would put a Filter tool down afterwards and set the custom query to be [Debit] = [Credit]. Anything that matches this will drop out of the T anchor, and anything that doesn't will drop out of the F anchor!
-Alex
You could also round if there are a lot of decimals - Round([Debit],0.01) = Round([Credit],0.01)
Also if you wanted a column reporting the difference between the two, you could use a Formula tool to calculate ABS([Debit] - [Credit]) and then use the Filter afterwards to find where [Difference] > 0 or whatever threshold you feel comfortable with.
Hi alex, I did try using filter tool, but shown as invalid
Hi @wenyg,
Are those the exact names of the debit/credit fields on your side? I just put generic names but the [Debit] field should match the column name of your Debit column - for example, if it's named [debits] then make sure it reflects as such in the Formula. Same thing with Credits as well!
In addition, make sure the fields are both numeric and not strings - typically these are stored as Double but could be stored as FixedDecimal or Float. You can check the Metadata in the Results pane quickly or put down a Select tool in between the Union and the Filter.
If you want more direct help on the workflow, go ahead and "Export Workflow" under Options - this will package the workflow and any relevant data together into a .yxzp file. Make sure to redact any sensitive data!