Data Table package

The Data Table package contains actions that enable you to perform various operations on the values of table variables. Use these actions to join or merge content, search for specific values, insert rows and columns, remove duplicate rows, and write values to a file.

Actions in the Data Table package

The Data Table package includes the following actions:
Note: If actions are missing when you open the bot with the default package version, ensure that you reinsert the actions and repopulate the fields.
Action Description
Assign A action no package Data Table.
Change column type action Alterar tipo de coluna.
Clear content action Limpar conteúdo.
Delete column action Excluir coluna.
Delete row action Excluir linha.
Get number of columns Get number of columns action.
Get number of rows action Obter número de linhas.
Insert column Inserir coluna action.
Insert row action Inserir linha.
Join Como usar a ação Mesclar.
Use the Exemplos de saída do tipo junção to help you decide whether to use the Join or Merge action.
Note: If you built a bot using this action from package version 2.0.0-20200624-042148 or earlier, the action will be missing when you open the bot with the default package version. You must reinsert the action and repopulate the fields.
Merge Usando a action Mesclar.
Use the Exemplo de saída de mesclagem to help you decide whether to use the Join or Merge action.
Note: If you built a bot using this action from package version 2.0.0-20200624-042148 or earlier, the action will be missing when you open the bot with the default package version. You must reinsert the action and repopulate the fields.
Remove duplicate rows action Remover linhas duplicadas.
Search for a value action Procurar um valor.
Set value of a single cell action Definir o valor de uma única célula.
Sort action Classificar.
Write to file action Usar a ação Gravar no arquivo.
Write to file stream Usar a ação Gravar no fluxo de arquivos
Example: Exemplo de extração de dados a partir de uma tabela da Web