Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Re: X, Y Table structure

by ww (Bishop)
on May 10, 2011 at 12:17 UTC ( #903964=note: print w/ replies, xml ) Need Help??


in reply to X, Y Table structure

Just out of curiousity, what use is a transformation such as you show, leaving a table with data that no longer has any link to its IDs?


Comment on Re: X, Y Table structure
Replies are listed 'Best First'.
Re^2: X, Y Table structure
by Anonymous Monk on May 10, 2011 at 14:32 UTC

    If you've seen my reply to ikegami, You can see that I've added IDs in my example.

Re^2: X, Y Table structure
by Anonymous Monk on May 10, 2011 at 12:28 UTC
    FWIW, AFAIK, its temporary, for creating reports, like SQLite::VirtualTable::Pivot shows
    Given this table : Student Subject Grade ------- ------- ----- Joe Reading A Joe Writing B Joe Arithmetic C Mary Reading B- Mary Writing A+ Mary Arithmetic C+ A pivot table created using the columns "Student" and "Subject" and th +e value "Grade" would yield : Student Arithmetic Reading Writing ------- ---------- ------- ---------- Joe C A B Mary C+ B- A+
    Because I forgot all about VIEWS/PIVOT, I did the transformation manually.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://903964]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2015-07-30 01:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (269 votes), past polls