We will show you how to build a table in the Datalexing system using a practical example with Ahmed, the owner of a café who wants to compare different suppliers for his project needs. He will use supplier and competitor data from CSV and Excel files.
After Ahmed assessed his project needs, he decided to enlist the help of a friend to provide him with various suppliers for his project needs so he can compare their prices and product quality.
However, Ahmed's friend provided him with an Excel file that outlines the supplier's name, a description of their products, along with their mobile number and a link to the supplier's website.
To transfer the data from the Excel file to Datalexing, Ahmed did the following:
Used the paste data feature from a table
Created a new table in Datalexing
Chose the option to paste data from a table
Copied the supplier data from the Excel file
Pasted the supplier data into the empty box, resulting in a small table showing the organized data
The user must ensure that the organization of the table matches the copied table. |
After adding it to the supplier table, Ahmed changed the column types as follows:
Name: Short text
Description: Long text
Mobile number: Phone number
Link: Link
Location: Multiple Select
Importing Data from a CSV File
Ahmed searched for competitors, their websites, and evaluated them in the field and found a CSV file that outlines the information. He wanted to add it to the system, so he did the following:
Created a new table and named it "Competitors"
Chose the option to import from a file (CSV)
Selected the file from his device and added it
A small table appeared showing the organized data
Ahmed added the table to the file
After adding it to the competitors' table, Ahmed changed the column types as follows:
Name: Short text
Type: Short text
Address: Long text
Latitude: Number
Longitude: Number
Price Type: Multiple choice
Likes Count: Number
Photos Count: Number
In this way, you can efficiently use Datalexing to manage and organize your project data. You will have organized tables containing information about suppliers and competitors, for example, according to the nature of your project. This made it easier for Ahmed to compare prices and product quality and make better decisions for his project.