Skip to content

Instantly share code, notes, and snippets.

@DGaffney
Created April 24, 2011 01:49
Show Gist options
  • Select an option

  • Save DGaffney/939231 to your computer and use it in GitHub Desktop.

Select an option

Save DGaffney/939231 to your computer and use it in GitHub Desktop.
| id | label | value | analysis_metadata_id | graph_id | curation_id |
+--------+----------------------------------------------------+-------+----------------------+----------+-------------+
| 474217 | https://www.google.com | 4 | 4 | 15 | 1 |
| 474216 | https://www.youtube.com | 10 | 4 | 15 | 1 |
| 474215 | https://www.internet.com | 7 | 4 | 15 | 1 |
| 474227 | https://www.google.com | 5 | 4 | 20 | 1 |
| 474226 | https://www.youtube.com | 16 | 4 | 20 | 1 |
| 474225 | https://www.internet.com | 3 | 4 | 20 | 1 |
From this, I would want to grab records pulled back as this:
| label | value_graph_id_20 | value_graph_id_15 |
+----------------------------------------------------+-------------------+-------------------+
| https://www.google.com | 5 | 4 |
| https://www.youtube.com | 16 | 10 |
| https://www.internet.com | 3 | 7 |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment