# How to pull/ copy data from another table **URL:** \ **Category:** Ask for Help\ **Created:** [April 14, 2024, 5:22am UTC](https://community.glideapps.com/t/how-to-pull-copy-data-from-another-table/72557 "2024-04-14T05:22:48Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![mgalihm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgalihm/32/73257_2.png) [@mgalihm](https://community.glideapps.com/u/mgalihm)\ **Post date:** [April 14, 2024, 5:22am UTC](https://community.glideapps.com/t/how-to-pull-copy-data-from-another-table/72557/1 "2024-04-14T05:22:48Z")
how can i pull the data from this table ![ask glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d68666887a145f251b603b9bafcd478048a51ac.png) to this ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d727034fc250bfa0adbe27727bb5b9f99cb855ce.png) ---
**Author:** ![Sekayi\_Liburd](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sekayi_liburd/32/77608_2.png) [@Sekayi\_Liburd](https://community.glideapps.com/u/Sekayi_Liburd)\ **Post date:** [April 14, 2024, 5:37am UTC](https://community.glideapps.com/t/how-to-pull-copy-data-from-another-table/72557/2 "2024-04-14T05:37:28Z")
> [@Gather data from one tab (data table within Glide) to another](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/2): > > A few random ideas: > > 1. Are you sure you need to copy data from one table from another? If possible I would consider other options first. > 2. **Table architecture**. Imagine I’m creating a Things tab on which I will display a collection of Things. In the Data Editor, I create a table called Things Tab and don’t touch it (I might touch it at the outset). I create a second table called Things Collection where I will store data related to the Things collection. Each of my tabs have their own table, each of my collections have their own table, and I keep these tables strictly separate. > 3. **One-off methods to copy data.** You can right-click on any table and duplicate it. You can right-click on any table and do a data import. You can select cells in one table and copy-paste them into another. Below the Users table, you can import a file. > 4. As long as the style of a tab is custom, any collection, and therefore any table, can live on any tab via a collection component. > 5. **Fetching data from another table.** You can leverage the Single Value column. In the destination table (the table you are copying the data to): > > - Create a dynamic RowIndex column: RowID column, lookup of RowID column, find element index of RowID column. > - Create a Single Value column to pull in a column from the origin table: Single Value column, from start, RowIndex, column from the original table. > - Repeat with Single Value columns to fetch additional columns. > > I hope this helps. Hi @mgalihm . I saw this in another thread. Does it help? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [April 14, 2024, 10:11am UTC](https://community.glideapps.com/t/how-to-pull-copy-data-from-another-table/72557/3 "2024-04-14T10:11:33Z")
A few further ideas: > [@Gather data from one tab (data table within Glide) to another](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/2): > > Each of my tabs have their own table, each of my collections have their own table, and I keep these tables strictly separate. If you do this for each tab and don’t use the tab table to configure anything in the Layout Editor, the Data Editor ends up “polluted” with many tab tables that do nothing. To avoid this, two ideas: 1. Use the Users table as the “general” table of the application. The Users table is then used as the data source for all tabs. I personally don’t do this. To me the Users table represents a collection, slightly different than any other collection, but not special enough that the table deserves to be both a collection and a one-row table to configure tabs. In general I dislike having a table that houses a collection (an item attribute per column) and the same table houses something entirely different such as data for the layout or an analytics dashboard. I prefer separating the data in separate tables. 2. Create a table called “All tabs” or “Global settings” or “General settings”, and use that table as the data source for all or most tabs. There, each tab has its own group of columns for layout purposes. > [@Gather data from one tab (data table within Glide) to another](https://community.glideapps.com/t/gather-data-from-one-tab-data-table-within-glide-to-another/65942/2): > > **Fetching data from another table.** You can leverage the Single Value column. The Query column is also good for this. ---
**Author:** ![mgalihm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgalihm/32/73257_2.png) [@mgalihm](https://community.glideapps.com/u/mgalihm)\ **Post date:** [April 14, 2024, 7:54pm UTC](https://community.glideapps.com/t/how-to-pull-copy-data-from-another-table/72557/4 "2024-04-14T19:54:12Z")
Hi, Thanks for your help ---
**Author:** ![mgalihm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mgalihm/32/73257_2.png) [@mgalihm](https://community.glideapps.com/u/mgalihm)\ **Post date:** [April 14, 2024, 7:55pm UTC](https://community.glideapps.com/t/how-to-pull-copy-data-from-another-table/72557/5 "2024-04-14T19:55:12Z")
Hi, Thanks for your help and information