Extracting Names from Columns to Rows in a Database Table

·

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!

· Sorted by Oldest

Morgann Dawance
·
·
Interested by the answer as well
Morgann Dawance
·
·
(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

Morgann Dawance
·
·
Interested by the answer as well
Morgann Dawance
·
·
(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