Creating a column in a table by appending the rows of 2 different columns in different tables.

[juststarting]

Let's say I have a column A in Table X that contains 10 entries

I have another column B in Table Y that contains 5 entries.

They both are type Text.

I have an empty column in Table Z, with the name "Combined".

I want to be able to import or copy the entries from X[A] and Y[B] and append all the rows so that the Column "Combined" in Table Z has 15 values.

I want Column "Combined" to be a physical column, not a virtual one.

It would also be great how to get rid of duplicate values in Column "Combined" if required in the future.

The source of all this data is google sheets.
Thanks!

[Steve]

Combined:

(X[A] + Y[B])

 Combined with no duplicates:

UNIQUE(X[A] + Y[B])

 See also: List expressions

[juststarting]

Hi Steve, thanks for the reply.

However, I get this error:

Column Name 'coil' in Schema 'New_Schema' has a 'List' type. Only virtual columns or inputs are currently allowed to have the List type.

How can I convert that list to a column or have the column fill with the values of the list ?

Thanks!

[Steve]

If you must store the combined list in the data source, make the column of type EnumList.