topic Re: Join - Excel - Multiple Fiedls in Data Management Questions

Join - Excel - Multiple Fiedls

LuisCosta3 — Fri, 07 Oct 2016 18:38:38 GMT

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.

Re: Join - Excel - Multiple Fiedls

DarrenWiens2 — Fri, 07 Oct 2016 18:40:11 GMT

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.

Re: Join - Excel - Multiple Fiedls

LuisCosta3 — Mon, 10 Oct 2016 23:07:10 GMT

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>

Re: Join - Excel - Multiple Fiedls

LuisCosta3 — Mon, 10 Oct 2016 23:08:22 GMT

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>