convert integer value column to list

pallavpallav Member Posts: 39 Contributor II
edited June 2020 in Help
I have a column i want to convert it to list .
Example-
CODE
34
45
65
76
78
56
91
83
94
85
48
39

i want to covert it list; output should look like 
'34','45','65', '76','78','56','91','83','94','85','48','39'

then want to store this list in a macro..

Best Answer

Answers

  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    Hi @pallav,

    You can find in attached file a process using Transpose/Generate Aggregation (option concatenation) operators
    which performs what you want to do ..


    Hope this helps,

    Regards,

    Lionel
  • pallavpallav Member Posts: 39 Contributor II
    Hi @lionelderkrikor - Thanks for help . But one thing seems to be missing .. it is giving 34,45,65, 76,78,56,91,83,94,85,48,39 instead i will need it to be sime thing like '34','45','65', '76','78','56','91','83','94','85','48','39' with quotes.
  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 Unicorn
    You can add the quotes prior to the Pivot transformation by adding the "Replace" operator and using the regular expression to add quotes around the items, although you may also have to add an operator to change the data type from numerical to nominal if the original values are all numerical so RapidMiner is treating it as a numerical field.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts
Sign In or Register to comment.