Skip to content

Merging Lists

Merging two lists (Join Lists) means appending columns from the second list to the columns of the first list. You can specify the numbers of the selected columns separated by commas (Extract Fields), for example: 1,2.

Example

Input list #1:

aaa@dmain.com,A1
bbb@domain.com,A2
ccc@dmain.com,A3
ddd@domain.com,A4
eee@dmain.com,A5
fff@domain.com,A6

Input list #2:

B1
B2
B3
B4
B5
B6

Merge result:

aaa@dmain.com,A1,B1
bbb@domain.com,A2,B2
ccc@dmain.com,A3,B3
ddd@domain.com,A4,B4
eee@dmain.com,A5,B5
fff@domain.com,A6,B6