How to Add Lists Together


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).



  • 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.