Sumif formula replication

Question

Hi,

I am new to Alteryx, so please do not mind it

I have two tables. In table 1 I have source data. In table 2, I am trying to do a SUMIF like function, where table 2 sums for the specific unique IDs from Total amount in table 1. Which tools can I use to to perform this function?

Table 1:

It has a unique ID and total amount

ShankerV · Answer

Hi @mibra036

Possibility 2: If the table 1 contains the repeated ID, then please use summarize tool to Group by Unique ID.

Then Sum the Total amount.

Many thanks

Shanker V

Possibility 2.yxmd

ShankerV · Answer

Hi @mibra036

Exploring 2 possibilities here.

Possibility 1.

As it has been already mentioned that the values in Table 1 are Unique, I recommend to join both the tables with the Unique ID to get the expected output.

Many thanks

Shanker V

Possibility 1.yxmd

binu_acs · Answer

@mibra036 you can join the summarised output to your second table will get the desired result

Sum_280223.yxmd