Combining columns from two tables with different column names into one

Question

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

ABLatLongCD

And another Table B

EFGHLatitudeLongitude

I want a table in the form

ABEFLat1=Lat + LatitudeLong2=Long + Longitude

Please Help!

Thanks!

Thableaus · Accepted Answer

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,