Open ManytoMany left.csv: | Open ManytoMany right.csv: |
L = readtable('ManytoMany left.csv') | R = readtable('ManytoMany right.csv') |
L = Key Veggies _____ __________ 'Mon' 'Broccoli' 'Mon' 'Celery' 'Mon' 'Lettuce' 'Wed' 'Broccoli' 'Wed' 'Celery' 'Thu' 'Broccoli' 'Thu' 'Celery' 'Thu' 'Lettuce' 'Fri' 'Broccoli' 'Fri' 'Celery' | R = Key Fruits _____ __________ 'Mon' 'Apples' 'Mon' 'Bananas' 'Mon' 'Cherries' 'Tue' 'Apples' 'Tue' 'Bananas' 'Wed' 'Apples' 'Wed' 'Cherries' 'Wed' 'Cherries' 'Fri' 'Apples' |
>> IJ = innerjoin(L,R)
IJ =
Key Veggies Fruits
_____ __________ __________
'Fri' 'Broccoli' 'Apples'
'Fri' 'Celery' 'Apples'
'Mon' 'Broccoli' 'Apples'
'Mon' 'Broccoli' 'Bananas'
'Mon' 'Broccoli' 'Cherries'
'Mon' 'Celery' 'Apples'
'Mon' 'Celery' 'Bananas'
'Mon' 'Celery' 'Cherries'
'Mon' 'Lettuce' 'Apples'
'Mon' 'Lettuce' 'Bananas'
'Mon' 'Lettuce' 'Cherries'
'Wed' 'Broccoli' 'Apples'
'Wed' 'Broccoli' 'Cherries'
'Wed' 'Broccoli' 'Cherries'
'Wed' 'Celery' 'Apples'
'Wed' 'Celery' 'Cherries'
'Wed' 'Celery' 'Cherries'
>> whos
Name Size Bytes Class Attributes
IJ 17x3 8248 table
L 10x2 4162 table
R 9x2 3914 table
Functions referenced:
More information:
--- The End ---