community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Combining columns from two tables with different column names into one

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!

Alteryx Certified Partner
Alteryx Certified Partner

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,

Labels