Help needed with missing currency

[Carol_Chiu]

I need to convert balances based on the currency, however, the currency is only displayed on the first row. The rows below are blank under Currency. I have multiple currencies on file. What tools can I use in Alteryx to tell the computer to use the same foreign exchange rate as the currency on first row, until a different currency is displayed.

Currency	Location ID Number	Balance
CAD	123	100
	234	250
	TOTAL	350
USD	234	200
	345	100
	TOTAL	300

[PhilipMannering]

Hi @Carol_Chiu 

You could and should use the MultiRow Tool.

See attached,

[Qiu]

@Carol_Chiu 
Basically similar with @PhilipMannering , but with your test data.

And what do you want to want to do with last 4 rows in your test data, they are grand total?

[messi007]

@Carol_Chiu,

Attached the workflow 🙂

Hope that helps!

[grazitti_sapna]

Hi @Carol_Chiu,

Here is my take on the problem.

[Carol_Chiu]

I will filter out the sub total rows. Thanks.

[Carol_Chiu]

Thank you for your help! Much appreciated.