Join - Excel - Multiple Fiedls

2356
3
Jump to solution
10-07-2016 11:38 AM
LuisCosta3
New Contributor

Need to do a join between a feature and one excel file.

Problem is that I need to join multiples columns in Excel with 2 columns in my feature. Some light how to do it ?

Eg:

Table.Excel

Col 1-Field Country;

Col 2-Field State;

Col 3-Field City;

Thank you, Luis.

Tags (2)
0 Kudos
1 Solution

Accepted Solutions
DarrenWiens2
MVP Honored Contributor

Concatenate the desired fields together in each file to make a unique match. E.g. "Country_State_City" in Excel matches "Country_State_City" in the feature class.

View solution in original post

3 Replies
DarrenWiens2
MVP Honored Contributor

Concatenate the desired fields together in each file to make a unique match. E.g. "Country_State_City" in Excel matches "Country_State_City" in the feature class.

LuisCosta3
New Contributor

Hi Adrian, thank you!

Great suggestion, thats a Macgeyver way but worked.

Maybe Esri should include it in next version.

Luis.

Em sexta-feira, 7 de outubro de 2016, Adrian Welsh <geonet@esri.com>

escreveu:

GeoNet <https://community.esri.com/?et=watches.email.outcome>

Join - Excel - Multiple Fiedls

Adrian Welsh

<https://community.esri.com/people/MidnightYell2003?et=watches.email.outcome>

marked Darren Wiens

<https://community.esri.com/people/dkwiens?et=watches.email.outcome>'s reply

on Join - Excel - Multiple Fiedls

<https://community.esri.com/thread/184169-join-excel-multiple-fiedls?et=watches.email.outcome>

as helpful. View the full reply

<https://community.esri.com/message/639762-re-join-excel-multiple-fiedls?commentID=639762&et=watches.email.outcome#comment-639762>

0 Kudos
LuisCosta3
New Contributor

Hi Darren, thank you!

Great suggestion, thats a Macgeyver way to do it.

Maybe Esri should include it for the next release.

Luis.

Em sexta-feira, 7 de outubro de 2016, Darren Wiens <geonet@esri.com>

escreveu:

GeoNet <https://community.esri.com/?et=watches.email.thread>

Re: Join - Excel - Multiple Fiedls

reply from Darren Wiens

<https://community.esri.com/people/dkwiens?et=watches.email.thread> in *Managing

Data* - View the full discussion

<https://community.esri.com/message/639762-re-join-excel-multiple-fiedls?commentID=639762&et=watches.email.thread#comment-639762>

0 Kudos