Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How to use a KML file's ExtendedData ?

I have a KML file which contains structured extended data (Schema / SimpleField) linked to each Placemark (polygon), looking like this:

<SchemaData schemaUrl="#kml_schema_ft_test">

    <SimpleData name="OBJECTID">37</SimpleData>

    <SimpleData name="NOM">Le Renfort</SimpleData>

    <SimpleData name="NO_COM_FEDERAL">6604</SimpleData>

    <SimpleData name="NO_COMM">4</SimpleData>

    <SimpleData name="CODE_SECTEUR">00</SimpleData>

    <SimpleData name="SECT_VILLE"> </SimpleData>

    <SimpleData name="NUMERO">0400050</SimpleData>

    <SimpleData name="CODE_SOUS_SECT">050</SimpleData>

</SchemaData>

See attached sample file.

I would like to use this extended data in QlikSense, but when I import the KML file, it only recognizes 3 fields:

  • sample.Name (the placemark's name)
  • sample.Point (always empty - where is this coming from ?)
  • sample.Area (this is the polygon defined in my file, i.e. the shape I want to use)

The related data fields are nowhere to be found.

Is it possible to retrieve the KML extended data in QlikSense ? How ?

Thanks in advance for your help.

Damien

12 Replies
Highlighted
Creator III
Creator III

Hi Robert,

I'm interested in using your R script to reformat a KML (SHP) file in order to create columns for "Ranch", "Lot", and "Grower" from the attached file.  Would you be able to help me revise your script so it will work with this file?

Thanks!

Highlighted
Contributor II
Contributor II

Read .KML file using .xml format, you would information in various tables, just import the one you want.

Thanks!

Highlighted
Partner
Partner

I believe this should be the correct answer (Abhalla2 provided) unless there is a better way. Reading the KML as an XML will allow you to access the additional data. You may need to add logic in your load script to transform/normalize the data, but I've never had issues going this route.