You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello @jakethaw .
I was playing around with your extension (quite useful btw) since I wished to use it to convert an EAV-formatted data representation into a more "standard" table.
The catch is that I would like all this to be a VIEW on existing data.
Ideally I would have something like this (which may in turn be a VIEW on the original data)
id entity_text attribute value
-------------------------------------------------------------
2 text1 name John
2 text1 surname Smith
5 text2 place Liverpool
5 text2 country UK
turned into
id entity_text name surname place country
--------------------------------------------------------------------------------------------------
2 text1 John Smith
5 text2 Liverpool UK
Now, I do not know beforehand what can appear in the attribute column of the first table, so I would have a VIEW to have the DISTINCT attribute names associated with an integer ID, to use it with your virtual table to get the output column names.
It sort of works, but at the second SELECT on the pivot table I get a segmentation fault.
I also don't know what would happen when adding data to the source table.
I guess I am asking too much but I would like to ask what would prevent to be able to achieve something like this.
Thanks in advance 👋
The text was updated successfully, but these errors were encountered:
Hello @jakethaw .
I was playing around with your extension (quite useful btw) since I wished to use it to convert an EAV-formatted data representation into a more "standard" table.
The catch is that I would like all this to be a VIEW on existing data.
Ideally I would have something like this (which may in turn be a VIEW on the original data)
turned into
Now, I do not know beforehand what can appear in the
attribute
column of the first table, so I would have a VIEW to have the DISTINCT attribute names associated with an integer ID, to use it with your virtual table to get the output column names.It sort of works, but at the second SELECT on the pivot table I get a segmentation fault.
I also don't know what would happen when adding data to the source table.
I guess I am asking too much but I would like to ask what would prevent to be able to achieve something like this.
Thanks in advance 👋
The text was updated successfully, but these errors were encountered: