how to merge two columns with, primary key

[Sshasnk]

Hi, I have two columns and I have merged them. Below example

Column 1;

Date

2021/12/06

Column 2:

Name

Alex

Jack

Tom

Ian

Output: 

Name	Date
Alex	2021/12/06
Jack	2021/12/06
Tom	2021/12/06
Ian	2021/12/06

[mceleavey]

Hi @Sshasnk ,

Simply use the Append tool. This will allow you to append the one to many (or many to many, be careful!).

M.

[binuacs]

Spoiler

[Sshasnk]

@binuacs @mceleavey  i tried it and I keep getting error "There were more than 16 records in the source"

[NickWaanders]

Check your settings at the Append Tool. You can change them in the configuration window at the bottom. Warn/Error on too many records being generated: Allow all appends. This will solve your problem.
You can also choose to warn if there are more then 16 records. This is because appending a lot of field will take a lot off time.