How to Add Lists Together

Goal

In some circumstances, an analyst may want to take the results of two lists and combine them into a single list. Specifically, the resulting list would contain all members of the original two lists (including any duplicates).

Learn

• To add two lists together the "+" function may be used. 

Here is an example:

1. Suppose that column "MyList1" contains ["1", "2", "3"]
2. Suppose that column "MyList2" contains ["a", "b", "c"]
3. Use the following function to add these lists:

#MyList1 + #MyList2

The result should be a single list of ["1", "2", "3", "a", "b", "c"].

Please note that both lists must be of the same data type in order to be added together.