This category provides actions for data transformation.
| Action Name | Description |
|---|---|
| Calculator | Calculator |
| ColumnRename | Rename columns |
| FilterRows | Filter rows using an expression |
| Flatten | Flatten a table to reduce the number of rows |
| GetMetadata | Get meta data |
| InsertKey | Add a column with a counter or a constant |
| PartitionedSort | Extend an existing sort across multiple fields |
| ReplaceStrings | Search and replace strings |
| SelectColumns | Select or drop columns |
| sort | Sort lines |
| Unflatten | Unflatten a table to increase the number of rows |
| aggregate | Compute aggregates (count, sum, mean,...) on a column |
| mergeSort | Merge multiple sorted entries into a globally sorted table |
| regexReplace | Replacement by regex |
| sampling | Sampling |
| dummifyVar | Create dummy variables |
| AggregateOnColumns | Compute aggregates (count, sum, mean,...) on a row |
| CalculatorVectorized | Add several columns with an expression |
| Action Name | Description |
|---|---|
| Append | Append several tables |
| FilterOnKey | Filter table according to a keys set |
| fuzzyJoin | Fuzzy join tables |
| DiceJoin | Fuzzy left join with in-memory table (using Dice similarity) |
| InMemoryJoin | Left or inner join with in-memory table containing duplicated slave keys |
| IntervalJoin | Join tables where keys are intervals and points |
| Join | Join sorted tables |
| JoinCDR | Join CDR |
| joinGIS | Join tables according to GIS data |
| MultiJoin | Multiple joins |
| Action Name | Description |
|---|---|
| JoinInput | Join several Gel files into one table |
| mergeSortInput | Merge multiple Gel files into a sorted table |
| unpackArchive | Unpack/decompress an archive |
| excelPdfExportation | Convert .xlsx to PDF |
| pptxPdfExportation | Convert .pptx files to PDF |
| wordExportation | Convert .docx to PDF, HTML or MHT |
| excelUpdate | Update formula-based cells inside Excel sheets |
| upgradeToXLSX | Upgrade .xls files to .xlsx |
| encryptXLSX | Encrypt XLSX file |
| decryptXLSX | Decrypt XLSX file |
| yxmdConvert | Convert yxmd files to pipeline |
| simpleFileOps | Simple file operations |
| downgradeToXLS | Downgrade .xslx files to .xls |
| zipfiles2 | Zip files |
| reorderFilesPerDay | Reorder files by date |
| readOneFilePerCell | Read many text files and place each complete file in a different cell |
| writeOneFilePerCell | Write each cell in a different text file |
| Action Name | Description |
|---|---|
| AzureStorageDeleteFile | Delete files from a container in an Azure Blob Storage |
| DropboxDelete | Delete files in Dropbox |
| ElasticSearchDelete | ElasticSearch delete documents |
| OneDriveDeleteFiles | Delete files from OneDrive |
| S3DeleteFile | Delete files in a S3 bucket |
| HuaweiOBSDeleteFile | Delete files from a Huawei OBS bucket |
| sftpDeleteFile | Delete file(s) on a SFTP/FTP server |
| ostDelete | OpenStack delete files |
| MailboxDelete | Delete files on a mailbox.org drive |
| suiteCRMDelete | SuiteCRM delete |
| GoogleStorageDeleteFiles | Delete files contained in a Google Cloud Storage bucket |
| GDriveDelete | Delete files from Google Drive |
| Action Name | Description |
|---|---|
| CreateTable | Create a table in a database through ODBC |
| columnNamesForDB | Simplify column names |
| Action Name | Description |
|---|---|
| sshRun | Run ssh command on a remote server |
| moveDataLake | Move the location of the datalake |
| Action Name | Description |
|---|---|
| AzureAddContact | Manage contacts inside Azure |
| dropContact | Dropcontact |
| DeepL | DeepL automatic translation |
| daVinci | Text completion with an openAI model |
| GoogleSpeechToText | Google cloud speech-to-text |
| Action Name | Description |
|---|---|
| eMailsFromFiles | Get all e-mail files inside a directory |
| Action Name | Description |
|---|---|
| CorrectSpelling | Correct text spelling |
| NaiveDeduplicate | Naive Deduplication |
| RemovePrefix | Remove a prefix |
| Accumulator | Accumulate a column |
| shiftColumns | Shift columns conditionally |
| shiftColumnsAdvanced | Shift columns conditionally (advanced) |
| Action Name | Description |
|---|---|
| ChangeDataType | Change column data types (to Key, Float, String) |
| PropagateDown | Propagate a cell to empty cells below |
| Split | Split columns into several |
| TransformDates | Transform a date for transactional analysis |
| aggregateInOneCell | Aggregate in one cell |
| numberFormatter | Number formatter |
| sha256 | Encrypts a column using SHA256 |
| splitRE | Split a column into several fields |
| squareSplit | Split a column into many constant-width columns |
| ActionCRC | Compute the checksum of a selection of columns on each row |
| addOpenDays | Add open days to given dates |
| updateExcelConnectionString | Update DSN connections strings inside .xslx files |
| concatString | Concatenate strings |
| distribute | Distribute rows between output pins |
| horizontalDedup | Deduplicate columns on a row |
| anonymizeSHA256 | Anonymize/Encrypt columns using SHA256 |
| splitVertical | Split a cell into several rows |
| Encrypt | Encrypt/decrypt a column (for anonymization) |
| Action Name | Description |
|---|---|
| ConcaveHull | Create a concav/convex hull |
| ExpandGIS | Expand/contract GIS geometries |
| SimplifyGIS | Simplify GIS geometries |
| reprojectGIS | Reproject GIS geometries |
| tesselateGIS | Tesselate the GIS plan |
| ConvertGIS | Convert between GIS geometry formats |
| createGISGrid | Create a grid of points/rectangles for GIS |
| GeometryInfo | Get details about a geometry |
| Action Name | Description |
|---|---|
| SmoothenRows | Compute average and sum of lines in a fixed size rolling window |
| convertTimeZones | Convert time between time zones |
| TimeTravel | Access the content of the rows above & below |
| SumOnRows | Sum sets of rows |
| TimeAggregate | Aggregate columns on a siking time window |
| Action Name | Description |
|---|---|
| ExtractNewColumnNames | Extract new column names |
| autoUnflatten | Automatic unflattening |
| dependencies | Search for all the data files required to create a final file |
| sortColumns | Sort columns |
| transpose | Transpose a table |
| versionPlusPlus | Compute the next file version number |
| ExtractDataFlow | Extract data flow between pipelines |