Apologies if this is a Data Table for Dummies 101 question but I am struggling to identify a simple way to replicate/copy a column with 7 x rows in one glide data table, into a second separate glide table ?
The individual columns with the 7 x rows of data are sitting within a Glide Data Table.
I need to use an IF-THEN-ELSE column function in order to create an ‘alert” based on the 7 rows of data falling within a specific range.
I created a new glide data table to handle the ‘alert’ function as my initial table is already massive and with the intent of keeping things cleaner and easily identifiable from a backend perspective.
Unfortunately I have not been able to identify a way to simply copy or recreate 1 column with 7 x rows of data from one glide data table into another glide data table…. please what am I missing here ?
You need to create an if-then-else column in the second table, or some other type of column?
If it’s a computed column, then it will need direct (or indirect) access to the same columns that are referenced in the original table.
If it’s a non-computed column, then simply create it and copy/paste the 7 rows of data.
Hi Darren,
I am aiming to copy/mirror the data in the Column with its 7 x rows in order to use the data in an if-then-else function.
The data in the original column across 7 rows is populated via an api call (refreshed every 12 hours). I wanted to have the if-then-else function in a separate dtat table as the oringinal table is already pushing past 150 columns…
So it’s just a Text type column?
Is the data the same in every row, or different?
Either way, use a Single Value column.
Sorry, I must be missing something here. The data is different in each row of the column. If I use a Single Value wouldn’t it just provide the first value (row 1) when I need all 7 rows of data in the column
That’s why I asked the question. Now I have enough information, I can provide a precise answer 
- In your second table, add a column to number your rows, beginning at zero
- Then add a Single Value column that targets the column in the first table, and select
N from start, where N is your row number.
Hmmm, apologies once again if this is a really basic concept that I am struggling to grasp.
First Table:
In my 2nd data table I have created:
The lookup in the second table is pointing to the column from the original table with the 7 x sets of data . I am looking for a way to copy all 7 rows of data from the first table column into the 2nd table column with all 7 rows replicated.
*When the data changes in the first column (across all 7 rows) based on api refresh, I need those changes to be replicated in the new column in the new table in order to trigger an alert when specific sets of data across a given day occur
Show me how your Single Value column is configured. It looks wrong.
From = column in original table
How do you set the Get: to be multiple rows ?
The Row part is wrong. You should reference the row ID column there instead of hard coding as 0.
These are the available selections (from the current/2nd table):
Yes, select Row ID.
By the way, that should be a number column, not a text column.
How did you go - did you get it working?
