Common Data Transformations After Importing Data

Discover how to make some common essential data transformations post-import data to your Xano database. Learn how to seamlessly migrate unique records, establish relationships for single values and arrays, convert text fields into arrays, and merge latitude and longitude fields into a geographical format.
00:00 - Intro
00:58 - Importing the CSV
03:16 - Unique values to a separate table
04:37 - Create a single value table reference
07:25 - Create an array of table references
09:48 - Latitute and Longitude text strings to Geo field
12:00 - A list inside a single text string to an array of texts (SPLIT)
13:46 - A single object from a text string to a single object field type
15:06 - A list of objects from a text string to an objects array
Xano - The Fastest No Code Backend Dev Platform
go.xano.co/4afbXtz
Twitter
/ nocodebackend
Subscribe to Xano's Channel for Weekly New Content
/ nocodebackend

[@AnthonyLavall]

Thanks for sharing! This video is missing chapters to help understand what each section covers FYI.

[@GustavoSantos-tx4de]

Great and clear video Louis. One question that I am puzzling. How to delete an object array since they don't have the id as reference. Let's suppose you want to delete or update the information on the counties you added. How the function should be looking like? Should I query for the text or create an id number?

[@nocodebackend]

Hi Gustavo! We replied to your question in the community. You can find the post here: community.xano.com/videos/post/common-data-transformations-after-importing-data-mg1ga5eWJuKlSdO