Replace wording

mengkoon007mengkoon007 Member Posts: 30 Contributor I
edited November 2018 in Help

Hi,

 

I have included a SQL statement in the read database oprerator, and manage to get the result. However, as per below picture, I need to replace those "Question" with wording, for example:

1 => Q1. How do you find the workplace?

2 => Q2. How do you find the job?

 

I am not sure if replace operator can be used and what should I set for the parameter? Can someone please kindly help. Thanks.

 

Replace.png

Database.png

Tagged:

Best Answer

  • mschmitzmschmitz Posts: 2,113  RM Data Scientist
    Solution Accepted

    Hi,

     

    first of all i would really recommend to use RM version 7. 

     

    Second: Did you think about a join? Create a table (in excel or in the data editor) with

    QuestionID      Question

    1                   How do you find the workplace?

    2                   How do you find the job?

     

    and join on the this ID. That's the cleanest way for me to do it. Especially if you have a growing table of questions.

     

    ~Martin

    - Head of Data Science Services at RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.