Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Re: X, Y Table structure

by ww (Archbishop)
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?

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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://903964]
[markong]: is there any mean to get notified if there are new replies in a thread?
[LanX]: Rat or newest nodes
[LanX]: I think there are RSS feeds you could use, but never used them

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2018-03-19 09:53 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (238 votes). Check out past polls.