Input file is Excel sheet - compare 1 column to another

Hi, fairly new to Alteryx

I have a summed column that I need to compare with data from the input to determine if there equal. If they are continue with a process else end.

The 2 fields are Deposit Amt(input) and Single Payment Amt(summed). I've attempted a filter tool without success.

Workflow

Accepted answers

All comments

apathetichell

are the two fields in the original data source or is one a summed tool? if it's the former - your filter is probably configured wrong ([Deposit Amt]=[Single Payment Amt]) if single payment amount is coming from a summarize tool/other source - use a join tool to find where the two values match.

atcodedog05

Hi @Apcvirgo1

Filter would be something like below. What's the issue you are facing?

Hope this helps : )

filter.yxmd

Apcvirgo1

Thanks, for the quick response.

The Single Payment Amt is not from the original data source and is summed and is Fixed Decimal. I use an append tool to include the sum in the original data and then remove all the lines except for the last with a sample tool. I entered your formula in the filter but the true anchor repeats the input.

apathetichell

Why are using the sample tool? that defeats the purpose. Are you looking for where the two entries are equal? get them in a standard numeric format (ie fixed decimal) or rounded double - and use a join to join on the two fields.

atcodedog05

Hi @Apcvirgo1

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

Apcvirgo1

I'm using the sample tool too remove unnecessary fields for the comparison with the deposit amt column.

Deposit Amt
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1249.27

Apcvirgo1

I'm using a sample tool because the deposit amt is a column of data and the number I need to compare will always be on the last row. Both numbers are in the same format - fixed decimal.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703