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

Currency File.xlsx

philipmannering

Hi @Carol_Chiu 

You could and should use the MultiRow Tool.

See attached,

currency fillldown.yxmd