Forum Discussion

javiercmh's avatar
javiercmh
Regular Visitor
9 years ago
Solved

Create relationship between a column values and many other columns that have those values as names

Hi,    I have the data from a survey which contains the items as columns like so (sorry this forum deleted my html tables :( ): id, it1, it2, it3 online1, 4, 2, 5 online2, 1, 3, 4   Then I hav...
  • MFelix's avatar
    MFelix
    9 years ago

    Hi javiercmh,

     

    The best way is on the query editor unpivot the "it1, it2,..." columns that way you would get a table with 3 values:

     

    IDAttributeValue

    Online 1it11
    Online 1it24
    Online 1it32
    Online 2it12
    Online 2it21
    Online 2it33

     

    then you could make the link between the two tables and work your information as needed.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi javiercmh,

 

The best way is on the query editor unpivot the "it1, it2,..." columns that way you would get a table with 3 values:

 

IDAttributeValue

Online 1it11
Online 1it24
Online 1it32
Online 2it12
Online 2it21
Online 2it33

 

then you could make the link between the two tables and work your information as needed.

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
9 years ago

MFelix,


Adding to other's post, you need to replace it1,it2,it3 with t1, t2, t3 in the unpivotted table in order to match the rows in the two tables.



Regards,
Lydia