0

I am simply trying to join 5 fields (different rows) with the same id to a single table with a matching single id using postgres/postgis/python.

The data looks like this:

enter image description here

and the table I am trying to join it to looks like this:

enter image description here

There is a similar thread that discusses this but I cannot figure out the logic to transfer all 5 data field row to one single row in the new table. Postgres - Transpose Rows to Columns

Any help is appreciated :)

JGH
  • 15,928
  • 4
  • 31
  • 48
Charles
  • 1
  • Can you give the desired output for your given example? And please as formatted text, not as picture – Islingre Sep 25 '19 at 19:05
  • Without desire output we can't help. Show us db schema, sample data, current and expected output. Please read [**How-to-Ask**](http://stackoverflow.com/help/how-to-ask) And here is a great place to [**START**](http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/) to learn how improve your question quality and get better answers. [**How to create a Minimal, Complete, and Verifiable example**](http://stackoverflow.com/help/mcve) Try create a sample in http://rextester.com – Juan Carlos Oropeza Sep 25 '19 at 19:45

0 Answers0