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?
Try this:
For Each Row( :My Column[] = my value[1]);
Try this:
For Each Row( :My Column[] = my value[1]);
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 ) )
)
);
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()])));