This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!
on 11-10-2015 01:26 PM - edited on 07-27-2021 11:45 PM by APIUserOpsDM
One of the great things about Alteryx is the ability to have multiple geography types (points, lines, regions) all contained within the same record.
However, when exporting map layers to MapInfo Tab file format, a decision has to be made of which spatial field to keep. What if you want all of them?!
Not to worry! The Transpose tool will save the day!
To configure the Transpose tool all fields will need to be selected under the Key Fields except for the spatial fields, they will be selected under the Data Fields.
Just note that there are now 2 fields for the radius. RadiusSize will correspond to the first trade area (row 2) and RadiusSize2 will correspond to the second trade area (row 3).
Now, more importantly all the spatial objects exist in one field (the Value field) and can now easily be exported to MapInfo.
Note: this methodology will also work for ESRI shapefiles, however, all the spatial objects must be of the same type. All points, all polygons...
(An example workflow is attached. This workflow was created in Alteryx 10.0)