We can use conditional split to decide if your column contains an Euro symbol or not. So based on data, there will be two flows, one Euro, another Non Euro. You can use the below expression in the Conditional split to have two flows.
instr(amount,'€')>0 For rows with Euro symbol in Amount column instr(amount,'€')==0 For Rows with No Euro symbol in Amount column
In my example below, i had two rows where i had Euro Symbol and one row did not have. Next to conditional split, i used a select transformation to rename column by appending '€'. Please follow below steps
#1: My source has a column Amount, which brings Euro symbol in two rows and dollar symbol in one row. Check Data preview tab
#2. Added Conditional Split to decide which has Euro and which has not
#3. Use select transformation, on top of the conditional split stream Euro and give Amount(Euro) as given below in column name. Here is where we do the alias naming of column
#4. See the data preview in Select, it shows the column name correctly with Euro symbol
#5. In the other stream, all the rows with non Euro are redirected.
#6. Data preview of the other stream has column name Amount (without euro symbol)
This method will work if you have Euro in all the rows or not present in any of the rows as well.
Please feel free to post questions if you have.