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' |
>> LJ = outerjoin(L,R,'Type','Left','MergeKeys',true)
LJ =
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'
'Thu' 'Broccoli' ''
'Thu' 'Celery' ''
'Thu' 'Lettuce' ''
'Wed' 'Broccoli' 'Apples'
'Wed' 'Broccoli' 'Cherries'
'Wed' 'Broccoli' 'Cherries'
'Wed' 'Celery' 'Apples'
'Wed' 'Celery' 'Cherries'
'Wed' 'Celery' 'Cherries'
>> whos
Name Size Bytes Class Attributes
LJ 20x3 9316 table
L 10x2 4162 table
R 9x2 3914 table
Functions referenced:
More information:
--- The End ---