"While exporting to Excel i need to replace

yogesh_kumaryogesh_kumar Member Posts: 1 Newbie
edited May 2019 in Help
I need to have blanks data while exporting to Excel but  it is exported with "?" symbols , Please help me to show only blanks instead of Question mark symbol..

Best Answer


  • Options
    kypexinkypexin Moderator, RapidMiner Certified Analyst, Member Posts: 291 Unicorn
    Hi @yogesh_kumar

    To add my 5 cents to @mschmitz answer. 

    Yes, it's only a matter of data display convention in RapidMiner. 
    But m,ost likely you'll need to use REPLACE MISSING VALUES operator after reading the Excel file. How you handle these blank cells with missing data also depends on the type of the missing values. If they are strings or text (which means nominal variables in RM), you can replace them with empty value or space. However, if they are numbers (numeric variables in RM), you can't leave them blank as you'd have to replace them with certain number as well (like zero, max, min, average of the column).
Sign In or Register to comment.