Quick Table

The Quick Table task in Gaio DataOS allows you to quickly create a table from small, manual data inputs — perfect for testing, prototyping, or entering reference values without uploading a full file.


How to Use

Follow these steps to create a table from pasted data:


1. Paste or Type Data

  • Use the input field at the top to enter your data in CSV format.

  • The first line should contain the column headers.

  • The second line onward should include the corresponding data rows.

Example:

col_1,col_2,col_3  
value,date,2

2. Click “Prepare data”

  • This will parse your input and generate a data preview.

  • Columns will be detected and their types automatically inferred.


3. Adjust Column Types (Optional)

  • Click on a column header to manually change its data type:

    • String, Int, Float, Date, DateTime, etc.

  • You can also delete columns using the trash icon.


4. Set Table Options

  • Result table: Enter the name of the table you want to create.

  • Options:

    • Active to drop table then create: If the table already exists, it will be dropped and recreated (use with caution).

    • Create reference on current process: Links the new table to the current data flow for further use.


5. Execute

  • Click Execute to finalize the creation of the table and load the data.


Use Cases

  • Create test datasets for development

  • Add small reference tables manually

  • Prototype transformations and visualizations

  • Manually define mappings or constants

Last updated