jointable

Join pairs of tables using arbitrary keys
1,1K download
Aggiornato 24 set 2009

Visualizza la licenza

usage: jointable(tab1,tab2,keys1,keys2,fillval)

JOINTABLE works much like an SQL join, where each row of the join corresponds to rows of the tables with matching keys. Positions corresponding to non-matching keys are filled with the specified value.

Examples:

jointable([1;2;3],[4;5],{'a','b','c'},{'a','b'}) % join on string keys
jointable({'a';'b';'c'},{'d';'e'},[1,2,3],[1,2]) % join on numeric keys
jointable([1;2;3],[4;5],ones(1,3),ones(1,2)) % join on non-unique keys

The treatment of non-unique keys differs from that of an SQL full outer join.

NOTE: Requires LEXCMP (see below).

See the help for more details.

Cita come

Ben Petschel (2024). jointable (https://www.mathworks.com/matlabcentral/fileexchange/25311-jointable), MATLAB Central File Exchange. Recuperato .

Compatibilità della release di MATLAB
Creato con R2009a
Compatibile con qualsiasi release
Compatibilità della piattaforma
Windows macOS Linux
Categorie
Scopri di più su Tables in Help Center e MATLAB Answers
Riconoscimenti

Ispirato da: lexcmp

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Versione Pubblicato Note della release
1.1.0.0

n/a