Populate empty target table with data from source

[UnknownUser]

Hi,

I have a target table, e.g:

Name

Age

Gender

Flag

the table is empty and only contains the field names. 

Now I have a source table that contains more information, e.g.

Name	Address	Age	Gender	Status	Flag
...	...	...	...	...	...

with thousands of rows of content. How do I populate my target table? 

[Thableaus · Accepted solution]

Hi @UnknownUser

Use the Union Tool with this option "Output Common Subset of Fields".

Cheers,