Input file is Excel sheet - compare 1 column to another

[Apcvirgo1]

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. 

[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 : )

[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.

[atcodedog05]

Hi @Apcvirgo1 

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

We will be happy to help : )