so in my "DATA" file, i have a currency column (column A); any row with "U$", the MV needs to be multiplied by the "Close" rate shown in the "FX" file ( that is, the rate shown in cell I10).
probably simple to do, but im a newb
this is your expected output?
thank you...almost...currency not blank is to left alone (or multiplied by 1 if that makes it easier)
Please see the attached workflow for the solution. Kindly note this is for case where we are picking value directly from the cell specified (I10).
thanks for the flow, but I need the MV for "U$" currency to multipled by the rate/number shown in the FX file, cell i10 (or alteryx, column F9, record 9)
Sorry I dont understand when I tried to make the "C$" rate = 1 , Alteryx makes it 0????
