Combination on two column.

[rohit782192]

This is a First Dataset

FirstName
Name1
Name2
Name3
Name4
Name5
Name6
Name7
Name8
Name9
Name10

and this is a second Dataset as below.

LastName
Surname1
Surname2
Surname3
Surname4
Surname5
Surname6
Surname7
Surname8
Surname9
Surname10
Surname11
Surname12

How we will combine list of all combination of first name and last name.

[Emil_Kos]

Hi @rohit782192,

Please let me know if it is helpful.

If not please let us know what is desired output. 

[jdunkerley79 · Accepted solution]

The simplest way is to use an Append Fields:

Make sure to change the drop down at the bottom to 'Allow All Appends'

Quick sample attached.

[rohit782192]

Your Output contains Null value.

[vizAlter]

Hi @rohit782192 — Can you try this: