convert integer value column to list

pallav

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..

lionelderkrikor

OK, I see, @pallav...

You can find the updated process in attached file ...

Does this process answer to your need ?

Regards,

Lionel

lionelderkrikor

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

pallav

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.

Telcontar120

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.