Create 1000 columns with similar formulas at one run

AsymptoticCos

I have an input column (ColumnA) that essentially has the Index of the table. I want to add 1000 numeric columns to this table. Each of the columns will add the column number to the original column. 

 

Example: the first new column will have the formula, ColumnA+1. 

30th new column will have the formula, ColumnA+30. 

jthi

If you really need formulas and not just values, here is one option

Names Default To Here(1);

dt = New Table("test",
	Add Rows(2),
	New Column("ColumnA", Numeric, Continuous, Values([1, 2])),
	Invisible // open/create as invisible! (or make invisible)
);

For(i = 1, i <= 1000, i++,
	Eval(EvalExpr(
		dt << New Column("ColumnA+"||Char(i), Numeric, Continuous, Formula(
			:ColumnA + Expr(i)
		))
	));
);

dt << Show Window(1); // if you need table visible later

If speed is important using Invisible is one thing you can do.