I had a infotable with values separate by "," , I should split that data and insert in to a location

[Bhargav1]

Hello,

I had a infotable with values separated by "," , I should split that data and insert in to a location basetype where using that location we should make a geofence on the map.

Please let me know how to split that data and insert into location base type.

find attached image for clarity.

Regards,

Bhargav.

[PaiChung · Accepted solution]

If you are looking to do a geofence you would need an infotable inside an infotable

outer table defines

RegionID RegionCoordinate RegionCoordinates

inner table RegionCoordinates has the set of coordinates