Table "Vertical Lookup", how to do it?

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

[Thorsten]

It would be helpful if you provide the tables.

Answer 1

[Mohammad Abouali]

Look up join() and outerjoin() commands.

Answer 2

[Peter Perkins]

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.

Answer 3

[Leonardo Urbano]

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