Extracting Names from Columns to Rows in a Database Table

Oliver M. · 2024-11-26T07:31:46.389175+00:00

https://www.loom.com/share/1272f35b24c446239864242ade66577c?sid=38d3db3d-099e-421f-98eb-14627529a7a2 Trying to figure out how to get a series of names from different columns in one table (write to other table doesn't allow you to write columns to rows) > rows in another table. If anyone knows how to do this, that would greatly appreciated. Thanks!

Morgann D.

·

Interested by the answer as well

Morgann D.

·

(I'm struggling with a similar situation)

Edem

·

You can use Chatgpt to structure the data in a json array. Example "teachers":[{"name": "title"}, {"name":"title"}] Remember to use json for the output. Then you can write to the rows in the other table

2

3 comments