I have two tables A and B. They have two common columns:
A's columns are Date, ID, col1, col2 etc...
B's columns are Date, X1, ID, X2 etc....
Columns 1 and 2 of A match columns 1 and 3 from B. "tried join, innerjoin functions and received errors probably because A and B have multiple columns that are different:. My question is how to produce table C that has every row in A and the rows of B that match those of A .So C would be somethings like [ Date,ID, col1,col2 ,X2,X2,etc...];I don't want the columns 1 and 3 in B to be reproduced (so, I don't want C to appear like [ Date1,ID1, col1,col2 ,Date2,ID2,X2,X2,etc...] and I want the rows of A that are not matched by B to have nans .
I am wondering what is the right command for this :
Dor example I tried
Error: Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for