KML output

I'm working on an app so any excel document with a lat/lon can be made into a KML document. The one request was to always have the first column be the name of the location. Now the name of the first column may change and I want to find a way to always use that first column whatever it's named. How can I do that when Name Field is looking for a specific name? Tried a few things that didn't work. Anyone?

Output

Dynamic Processing

Preparation

Accepted answers

DavidP

Something like this? If the name of the PROPID changes then you will have to change your filter tool as well.

input field name.png

update column name.yxzp

danilang

Hi @brad_j_crep

@DavidP has an excellent solution, but here's one that's a little simpler

Use Dynamic select to rename only the first column and then join all columns back on record position

1st column rename.png

Dan

KML output.yxmd

All comments

DavidP

You can use a dynamic rename to force the names of the columns to always be the same

DavidP

column names.png

column names.yxmd

brad_j_crep

Thanks! But what if I don't want to change all of the header names? Can I select out and change the first column header name to 'ID' and leave the rest as they were? Was trying to do this but didn't have much luck.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703