Forum Discussion
Relationship between Column Header and another table
I have a table of information about my column headers and would like to connected them. Is it possible to create a relationship between column headers and another table.
For example, like this (https://community.tableau.com/thread/152991) in Tableau.
Thank you!
Looks to me like this is only possible when you transpose TableA.
Below the code how it looks like in Query Editor - Advanced Editor:
let Source = TableA, #"Demoted Headers" = Table.DemoteHeaders(Source), #"Transposed Table" = Table.Transpose(#"Demoted Headers") in #"Transposed Table"Compilation picture of the resulting table and the relationships:
Going offline now as it's almost midnight over here.
Maybe there is a workaround to achieve what you eventually require.
I mean: creating a relationship can never be the end goal.
Proabbly you want to end up with some visual(s) with information from both tables.
9 Replies
Maybe you can use Table.ColumnNames in Power Query.
For more specific help, please provide more specific information about your data and your requirements.
If the required information is in the link you provided, please be more specific where exactly in the link the information can be found.
Thank you for your reply MarcelBeug.
My issue is almost identical to that of Kirstin's in this (https://community.tableau.com/thread/152991) Tableau forum.
Like Kirstin, I have columns in a table, say A, called f1, f2, ..., f100 (these are Table A's column headers). I also have another table, say B, with corresponding specifics, such as fi's (for i from 1-100) exact question and question type. However, in Table B, I also have a column, say b1, containing each question's id, the fis from above. I'd like to create a relationship between Table A's column headers and column b1 from Table B. Is this possible? How can I do this? Can I do this without downloading Power Query?
Anything is possible with Power Query, which is the "Query Editor" part of Power BI, so it comes with the product.
I painted a picture how I understand your input would look like. Table A to the left and table B to the right.
Now you may paint a picture how the result should look like.
