Connecting two tables where the rows in one correspond to column headers in the other

[hsfo]

Hi, 
Im trying to connect two tables where the row values in one are listed as column headers in the others. The caveat is that I need the column headers to stay in that shape (i.e transposing directly won't work). 

Example: Lets say we are predicting house prices. We have a table with features and their importance (table 1). We also have a table with some houses and the values for those features. We need to be able to connect the information about the feature importance when analyzing the observations of the specific houses. 

Table 1

Feature	Importance
Floor size	0,9
Number of bathrooms	0,8
Number of bedrooms	0,7

Table 2

House ID	Floor size	Number of bathrooms	Number  of Bedrooms
house_1	3894	3	4
house_2	1250	1	2

How can I connect the features that are shown as rows in table 1 with the features shown as columns in table 2? 

I need the data in the table 2 columns. 

I need to be able to rank the columns based on importance. Any ideas on how to do this? 

[jbwtp]

Hi @hsfo,

There are few options to do what you want. The simpliest can be pivoting Table1 and then appending to Table 2, in this case you will have the weights "data in the table 2 columns" as you wanted.

I wonder, however, what are you going to do with this data? "rank the columns based on importance" sounds a bit strange. If you order columns according to thier weightings it is not going to provide any benefit in the report as the Designer really does not care about the columns order in the data, this is only a sequence of field in a visual [e.g. a table] that sets the order of appearance.

What is you ideal output?

Thanks,

John