# Insert data from big table into a normal glide table **URL:** \ **Category:** Ask for Help\ **Created:** [June 17, 2024, 5:08am UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180 "2024-06-17T05:08:29Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [June 17, 2024, 5:08am UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/1 "2024-06-17T05:08:29Z")
I have data in a big table like | A | B | C| | 1 | 2 | 3 | | 1 | 2 | 3 | | 2 | 2 | 3 | I would like to query the big table where A=1 and then insert the data into a Glide table. This table would have a lot more columns Glide table | A | B | C| | 1 | 2 | 3 | | 1 | 2 | 3 | How to do that in Glide? Or would it more sense to use MAKE (which I haven’t really used yet) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 17, 2024, 5:41am UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/2 "2024-06-17T05:41:13Z")
Have you tried using query or relation columns? Or do you mean to create a duplicate column, you can use Glide api? ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [June 17, 2024, 2:47pm UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/3 "2024-06-17T14:47:54Z")
@Himaladin I need to copy the data from the big table and paste them to another table. I have tried relation and query column - but cannot see how to run these other than hitting a button in the builder (so not accessible to the user) ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 17, 2024, 4:34pm UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/4 "2024-06-17T16:34:24Z")
If I don’t misunderstand what you mean. Have you turned on this section? ![Screenshot 2024-06-17 at 23.23.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/1/01d5697ac41e5d790b0c923b9bac7afa344ef8c7.png) ![Screenshot 2024-06-17 at 23.40.17](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d9af68e812a58dd3dc8fa3d52201548a31469214.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 17, 2024, 11:02pm UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/5 "2024-06-17T23:02:25Z")
> [@Krivo](#): > > I have tried relation and query column - but cannot see how to run these other than hitting a button in the builder (so not accessible to the user) So you need to automate this on a time-based schedule? ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [June 18, 2024, 4:32am UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/6 "2024-06-18T04:32:17Z")
@ThinhDinh no - the copying should take place when the user hits a button ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 18, 2024, 4:59am UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/7 "2024-06-18T04:59:44Z")
So you just want your user to copy a number of rows from the bigtable to a regular table with a single button press? ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [June 18, 2024, 5:19am UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/8 "2024-06-18T05:19:06Z")
Yes - that’s correct. The rows must fulfill certain criteria- so a filtering before the copying takes place ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 18, 2024, 5:28am UTC](https://community.glideapps.com/t/insert-data-from-big-table-into-a-normal-glide-table/74180/9 "2024-06-18T05:28:23Z")
Apart from the first method that I mentioned above, you might be able to use this alternative method [https://youtu.be/b7\_k3\_brusQ?si=7ou2AIHe-wDZe0vv](https://youtu.be/b7_k3_brusQ?si=7ou2AIHe-wDZe0vv)