How to read/pass on Euro symbol in text based on Excel file

[NitinThukral]

HI Team,

I have mapping set based on text that contain Euro symbol. Alteryx read it as '?" moreover it drop off in Join tool. any suggestion how to Alteryx can read Euro symbol correctly.

[martinding]

Hi @NitinThukral ,

What field type are you using?

If you using VW string or W string, it should work with the Euro symbol.

String, and vstring, tend to not work with €.

Please see the attached workflow as an example.

 

[NitinThukral]

Hi Martinding,

Thanks for your response.

I change it to W string. However it corrected partially. (mapping appear fine. Input still showing "?" in alteryx).

Any further suggestion.

[Armon24]

Hi @NitinThukral 

You could try using the ReplaceChar function in the formula tool. Switching out the "?" for the "Є". 

[PanPP]

Hi @NitinThukral 

Maybe try modifying the Code Page option in the Input tool config window to ANSI - Central European. It seems to pull in the euro sign on my local Designer instance

Hope this helps. If it does, please like this post and mark it as a solution.

[martinding]

Hi @NitinThukral ,

If the problem is at the input level, then like @PanPP suggested, try a few variations with the Code Page configuration.

Hope that works for you. Cheers!

[NitinThukral]

Hi, I change input data to W string(VW string not shown) however some input/record drop off. Moreover code page configuration option also not shown in Alteryx as input file is excel not .csv.

Note : Originally data was V_String.

Thanks!

Nitin 

(Happy to connect. Mob. +918802256848)

[PanPP]

1) As an option you can convert the excel file to a .csv to read in the file, and then output to .xlsx.

2) You can use a formula expression to change the special character to Euro ( ReplaceChar([ColumnName] , "?", "€") )

Hope this helps. If it does, please like the post and mark it as a solution.