Adding random numbers in collumn to get 0

[Laurami]

Hello all,

I'm creating a reconciliation flow, where i'm matching two files and then sometimes the values in unreconciled difference comes to 0, which would mean that the unreconciled lines are way smaller.

as for example bellow the only amounts that doesn't have its "other half" would be 789.41

Iis there any way in Alteryx to check if any of these amounts comes to zero? as currently its manual and it takes some time if there are new lines

[IraWatt]

Hey @Laurami,

There are loads of ways to do this. without knowing how your data is structured its hard to say which is the right way. Is there a column for instance to say which rows need to reconciliation with each other. Here is a basic approach I would use with just the data from the screen shot

It counts how many of each value there is. If there is not an even number it does not sum to zero.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com