Ordinary Least Squares (OLS): How can I choose Explanatory Variables from an other attribute table than Dependent Variable?

[EllaKeijser]

I try to run a Ordinary Least Squares (OLS) analysis to find a correlation between two continuous variables. As an Input Feature Class I choose the dataset of the dependent variable, in my case the "AED rate". Then, as a Dependent Variable I choose the right field that goes about the AED rate. Secondly I want to choose the right Explanatory Variable(s). I only can choose fields from the same dataset as the AED rate dataset. However, I need a field from another attribute table. Is that possible? And if yes, how can I do that?

[DanPatterson]

the other table would have to be Joined to your primary table, which means you will need a common field between the two tables to perform the join