We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
hacketkm
Level III

Assign a value in a list to column values

By using a modal window, the user assigns a value (for example "ABC10") to a variable (my value) and I would like to fill a column with that value. My code looks like this:

my value = { "ABC10" };

dt << New Column( "My Column");

For Each Row( :My Column[] = my value);

I am having trouble because my value is a list and the expression does not fit available column types. Can anyone help me out?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
pmroz
Super User

Re: Assign a value in a list to column values

Try this:

For Each Row( :My Column[] = my value[1]);

View solution in original post

3 REPLIES 3
Highlighted
pmroz
Super User

Re: Assign a value in a list to column values

Try this:

For Each Row( :My Column[] = my value[1]);

View solution in original post

Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Assign a value in a list to column values

It's easy to do this as you create the column with the Set Values() message, which takes a list as it's argument.

You can also use the Repeat() function to ensure that the list is repeated for all the rows in your data table.

dt =

New Table( "my table", add rows( 10 ) );

my value = {"ABC10"};


mycol = dt <<

New Column( "My Column",

  character,

  set values(

  Repeat( my value, N Row( dt ) )

  )

);

-Jeff
Highlighted

Re: Assign a value in a list to column values

You can also use this to create a table with the elements from a list.


a={1,2,3,4,5};


tmp=new table("test",add rows (nitems(a)),new column("list A",numeric,set each value(a[row()])));