join

Syntax

join(X,Y) or X<-Y

Arguments

X and Y can be scalar/vector/matrix/table.

Details

Merge X and Y.

Examples

If X is a scalar, Y can be a scalar/vector. The result is a vector.

$ 1<-3;
[1,3]

$ 4<-1 2 3;
[4,1,2,3]

If X is a vector, Y must be a scalar/vector. The result is a vector.

$ [1,2,3]<-4;
[1,2,3,4]

$ [1,2,3]<-[4,5,6];
[1,2,3,4,5,6]

If X is a matrix, Y must be a vector/matrix with the same number of rows as X. The result is a matrix with the same number of rows as X.

$ 1..6$2:3 <- [7,8];

#0	#1	#2	#3
1	3	5	7
2	4	6	8

$ (1..6$2:3) <- (7..12$2:3);

#0	#1	#2	#3	#4	#5
1	3	5	7	9	11
2	4	6	8	10	12

If X is a table, Y must be a table or a vector with the same number of rows as X. The result is a table with the same number of rows as X.

$ a=table(1..3 as x, 4.5 6.7 8.5 as y);
$ a;

x	y
1	4.5
2	6.7
3	8.5

$ b=table(700 500 800 as z);
$ b

z
700
500
800

$ c=join(a,b);
$ c;

x	y	z
1	4.5	700
2	6.7	500
3	8.5	800

$ a=table(1..3 as x, `IBM`C`AAPL as y);
$ b=table(172.3 25 106.5 as z);
$ c=a<-b;
$ c

x	y	z
1	IBM	172.3
2	C	25
3	AAPL	106.5

Related function: cj (cross_join)