Wildcard in Alteryx (Coming from excel using sumif)

[fordfold]

Hi Trying to move some work from Excel into Alteryx. Basically I have a cross tab that groups data by one field of variable length in one currency. Then I have another set of data in another currency that uses the same field but it has a space then other text within it. In excel I just used a sumif    =SUMIF(A2:A5,G2&"*",B2:B5)  This links the data together and then I can easily find the exchange rate between them  Not not sure how to replicate the sumif with wildcard in Alteryx?

[JordyMicheal]

Where there is a will there is a way hahaha

Nice @GiuseppeC , I didn't catch that either

[GiuseppeC]

Indeed! Thanks, @JordyMicheal!

[fordfold]

Brilliant and so simple. Been bugging me all day. Thanks.