Combining columns from two tables with different column names into one

[VipulNarang]

Hello,

I have just started using Alteryx and i have this task for a visualization i am working.

I have a table A with has, fields in the following format

A	B	Lat	Long	C	D

And another Table B 

E	F	G	H	Latitude	Longitude

I want a table in the form 

A	B	E	F	Lat1=Lat + Latitude	Long2=Long + Longitude

Please Help!

Thanks!

[Thableaus · Accepted solution]

Hi @VipulNarang 

It really depends on how you're pullling data, there are many different ways to do this.

But one of them would be changing the column names with a Select Tool to a standard name and then use Union Tool to union your datasets.

Cheers,