Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

convert integer value column to list

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

Find more posts tagged with

AI Studio

Accepted answers

lionelderkrikor

OK, I see, @pallav...

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

Does this process answer to your need ?

Regards,

Lionel

column_to_list_2.rmp

All comments

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

column_to_list.rmp

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.

lionelderkrikor

OK, I see, @pallav...

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

Does this process answer to your need ?

Regards,

Lionel

column_to_list_2.rmp

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.