2.2.17. addLinked
Purpose
Add data of selected column(s) from (first) row of linked ASCIItable that shares the linking column value.
Usage
> addLinked options ASCII table(s)
Options
-
--link
- column labels of table and linked table containing linking values
-
-l
/ --label
- column label(s) to add from linked ASCIItable
-
-a
/ --asciitable
- linked ASCIItable
Examples
- add squared values
Suppose we have a reference ASCIItable containing data to which we want to add the squared values of column » y «. 2 head
# reference ASCIItable
x y
1 1
2 3
3 4
The lookup table contains 2 head
# lookup ASCIItable
value squared
1 1
2 4
3 9
4 16
5 25
> addLinked --link y value --asciitable lookup --label squared < reference
yields 3 head
# reference ASCIItable
# addLinked --index y value --asciitable lookup --label squared
x y squared
1 1 1
2 3 9
3 4 16