Table "Vertical Lookup", how to do it?

1 次查看（过去 30 天）
Leonardo Urbano
Leonardo Urbano 2015-4-6
回答： Leonardo Urbano 2015-4-7
Hi everybody,
I'm asking you help to discriminate a table according a precise criteria, I'm better explaining:
- I have 2 different tables got from Google Finance, one different in length to the other (i.e. a is the longer and b is the shorter). I want to make the discrimination according to the "Date" field;
- I want to looking for each value of b in a and create a matrix C with all rows of common values (e.g. if the value of the discriminant column (the Date column) is in common, then take all the row of a and copy in C, for each common value);
I have already tried to set a for statement up with a if statement within it, but my matter is that the two discriminant columns are not in the same order (one has only business days while other has all days, so 365 vs. ~250) and I can't tell Matlab to do some similar to the Vertical Lookup in Excel.
I hope to has been clear enough!
Thanks in advance to everyone
Leo

请先登录，再回答此问题。

采纳的回答

Mohammad Abouali
Mohammad Abouali 2015-4-7
Look up join() and outerjoin() commands.

更多回答（2 个）

Peter Perkins
Peter Perkins 2015-4-7
编辑：Peter Perkins 2015-4-7
It's not terrible clear what you're asking for. A simple example would have helped.
It sounds like you want to do a join operation. Consider putting your data into two MATLAB tables, and using the JOIN method.
Leonardo Urbano
Leonardo Urbano 2015-4-7
Thank you for replies!
I have solved making few steps more but building a more generic for statement based on the function busdays() and cutting off all unneeded data.
Thank you again!
Leo

类别

在 Help Center 和 File Exchange 中查找有关 Financial Toolbox 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by