Gaio DataOS
English
English
  • Welcome to the Gaio Platform documentation!
  • Documentação
    • General information
      • Functioning Structure
      • Login
      • Home page
    • Applications
    • Studio
      • Suit
      • Data Sources
      • Tasks
        • ETL
          • Builder
          • SQL
          • SQL External
          • Insert Table
          • Insert Row
          • Update
          • Delete
          • Create Table
          • Quick Table
          • pivot table
          • Unpivot Table
          • Run Process
          • Rest
          • Parameters to Table
          • Table to Parameters
          • Users
          • CSV Web
          • Google Planilhas
        • Analytics
          • Sample
          • AutoML
          • Scoring
          • Cluster
          • Main Components
          • Association Rules
          • Time Series
          • Python
        • Delivery
          • Report
          • Power Search
          • Content
          • Form
          • Exportar Output
          • Banner
          • Export CSV
          • Map
          • Insights
          • API
          • SMS
          • Whatsapp
          • Email
          • Network
      • Parameters
      • Forms
      • Files
      • Action Buttons
      • Top Menu
        • SQL
        • Edit Bucket Tables
        • Executions in Progress
        • Map Editor
        • Schedule
        • Models
        • Cognitive
        • Error log
        • Edit Dashboard
        • Chat - GPS
        • General Menu
    • Administration
      • Permissions
      • Users
      • Data Sources
      • Repositories
        • Creation
        • Data Management
      • Sharing
      • Schedules
      • Logs
    • Keyboard Shortcuts
  • Integrações
    • LDAP
  • HUB
    • Exemplos
      • Tarefa Conteúdo
        • Manual Form
  • FAQ
  • Gestão de Servidor
    • Gaio startup
  • What's New!
    • Release Notes
      • 2022
  • Import
    • Editor de Mapas
    • Parâmetros
    • Formulários
    • Processos
    • Editar Dashboard
    • Administração
      • Usuários
        • Permissões
      • Fontes de Dados
      • Repositórios
        • Criação
        • Gestão de Dados
      • Compartilhamento
      • Agendamento
      • Log
    • Consulta
Powered by GitBook
On this page
  1. Documentação
  2. Studio
  3. Tasks
  4. ETL

Update

PreviousInsert RowNextDelete

Last updated 1 year ago

Updating a column's value can be automated with the Update task . The main sources for this update come from Dashboards and APIs, which deliver data to the process via Parameters. These parameters can be used to signal which rows should be updated, as well as to inform which new values should be inserted.

Inform which columns will be updated and the values they will receive and then inform the criteria that the rows that will be updated must meet.

city column will be updated with the value NYC in all rows that have the value 123 in the customerNumber column .

This task can only be executed or saved so that whenever the process is executed, the update occurs.