Need suggestion on best way to add table column for an ID that does this....

csoon1

Basically I have this original table:

                                      

Column A	Column B	Column A	Column B
a	e	i	m
b	f	j	n
c	g	k	o
d	h	l	p

Now what I want to do is to create another table with a "new column ID" that looks like this

                                                                                                                                                                        

New   Column ID	Column A	Column B	Column A	Column B
1	a	e	i	m
1	b	f	j	n
1	c	g	k	o
1	d	h	l	p
2	a	e	i	m
2	b	f	j	n
2	c	g	k	o
2	d	h	l	p
3	a	e	i	m
3	b	f	j	n
3	c	g	k	o
3	d	h	l	p
x	a	e	i	m
x	b	f	j	n
x	c	g	k	o
x	d	h	l	p

What I have on my mind now is to clone the original table by creating a subset. And on this subset I add the "new column ID" with a certain value (the same for all rows). I repeat the same process creating as many subsets as needed (with each subset a "new column ID" is added). After I am done, I can just concatenate all subsets into one table.

I want to know if you have better ideas that you can share.

ms

You do not need to make subsets to concatenate multiple copies. You can just add the original table multiple times in the concatenate dialog. If the new ID is a counter a column formula can be used to generate the ID.

A jsl example:

// Stack dt n times

dt = Current Data Table();

n = 10;

tables = Repeat({dt}, n-1);

new_dt = dt << concatenate(tables);

new_dt << New Column("New Column ID", Numeric, Formula(Ceiling(Row() / 4)));