outer join of multiple tables

I have multiple (about 15) csv files that I would like to outerjoin. I would like to know whether there is a simple way to write the code.

5 Commenti

Rik
Rik il 6 Giu 2018
I'dd suggest writing a loop. What did you already try?
alpedhuez
alpedhuez il 6 Giu 2018
Modificato: alpedhuez il 6 Giu 2018
Suppose I have tables A, B, C, ..... What does this loop look like?
Stephen23
Stephen23 il 6 Giu 2018
Modificato: Stephen23 il 6 Giu 2018
Z = load first CSV file
for k = 2:number of CSV files
A = load next CSV file
Z = outerjoin(Z,A);
end
alpedhuez
alpedhuez il 6 Giu 2018
Yes. Then the filename should be well-behaved and indexed with k?
Stephen23
Stephen23 il 6 Giu 2018
Modificato: Stephen23 il 6 Giu 2018
" Then the filename should be well-behaved"
I don't know what a "well-behaved" filename is. There is absolutely no requirement that the filenames have to follow any particular naming convention or sequence. You might like to read this:
"and indexed with k?"
Yes, that is the point of using a loop.

Accedi per commentare.

Risposte (0)

Categorie

Scopri di più su Loops and Conditional Statements in Centro assistenza e File Exchange

Prodotti

Richiesto:

il 6 Giu 2018

Modificato:

il 6 Giu 2018

Community Treasure Hunt

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

Start Hunting!

Translated by