Extracting select data from excel sheets
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Hello.
I am currently trying to merge data from two excel sheets (A and B) into a third excel sheet (C):
A = xlsread('file1','sheet','column1');
B = xlsread ('file1','sheet','column2');
C= xlsread('file2','sheet','column');
A and C are similar; A has every value of C, but C does not have every value of A (i.e., A is longer and contains values that are not present in C). Moreover, A has corresponding values in B. I need to extract all of the values for A and B that correspond with C while leaving all other values as NaN. Is this possible?
1 Commento
dpb
il 5 Giu 2019
Makes no sense -- you start off with no C but then the description of the development of the content of C is dependent upon existing C content.
Try again to describe what A and B contain and what merge operation you're after.
Probably a short(ish) example would ease the comparison.
Look at the various join operations and/or ismember and related friends...
Risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!