Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

PQ Help with Arranging Tables for Relationships

I think this is a relatively straightforward one but I cannot for the life of me figure it out. I have some survey data that has respondents in rows and questions in columns with the responses to eac...
Need Help
  • m_dekorte's avatar
    m_dekorte
    3 years ago

    Hi Anonymous,

     

    Select the Person column in Table 1, on the Transform tab select: Unpivot Columns, Unpivot Other Columns

    Now you can Merge Table 1 and Table 2 setting the appropriate fields as keys (hold down CTRL when you select more than one combination) like so, the [Attribute] from Table 1 with Column 1 from Table 2 AND the [Value] from Table 1 with Column 2 from Table 2

     

    Ps. If this helps solve your query please mark this post as Solution, thanks!

m_dekorte's avatar
m_dekorte
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Hi Anonymous,

 

Select the Person column in Table 1, on the Transform tab select: Unpivot Columns, Unpivot Other Columns

Now you can Merge Table 1 and Table 2 setting the appropriate fields as keys (hold down CTRL when you select more than one combination) like so, the [Attribute] from Table 1 with Column 1 from Table 2 AND the [Value] from Table 1 with Column 2 from Table 2

 

Ps. If this helps solve your query please mark this post as Solution, thanks!