5. Detailed description of the Actions

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

5. Detailed description of the Actions

 

 
Common Input Actions

In-Line table         CSV file reader         Anatella “Gel” file reader (row-based Storage)         Generic ODBC reader         Generic OleDB reader         SQLite Reader – GIS support         5.2.7. Anatella “Columnar Gel” file reader (column-based storage)         Excel File Reader         SAS (.sas7bdat), SPSS (.sav and .por) and STATA (.dta) File Reader         XML/HTML File Reader         JSON File Reader          

 
Uncommon Input Actions

Merge Sort Input         (old) SAS file reader         Join Input         Square File Reader         Get Emails         Edi-Fact / X12 Reader         Read Excel Sheets Names         Query SMS Delivery Status         TCP-IP Receive table         Streaming data processing using an HTTP source/sink         MQTT Subscribe (IoT connector)         MQTT Unsubscribe (IoT connector)         Oracle OCI Connector         Outlook Get         Read SAP tables         Read QVX         Read Parquet files         clip0819         clip0820b         Read .yxdb Alteryx file         Read XDF file         Extract Data from Cryptographic Certificates         Read Sheets Metadata from Excel files         Read the Old Excel File format          
 

 
Run Control

Run to finish Line         Parallel Run         Multithread Run         Row Counter          
 

 
Join Tables

Append (High-Speed action)         Join (High-Speed action)         Multi Join (High-Speed action)         Filter On Key (High-Speed action)         Interval Join (High-Speed action)         In-Memory Join (High-Speed action)       Collate         Merge CDRs         Fuzzy Join (JavaScript action)         GIS Join          
 

 
Standard

Change Data Type (High-Speed action)         Sort (High-Speed action)         5.5.3. Partitioned Sort (High-Speed action)         Aggregate (Group by) (High-Speed action)         Merge Sort (High-Speed action)         Column filter (High-Speed action)         Flatten (High-Speed action)         Unflatten (High-Speed action)         Insert Key (High-Speed action)         Replace String (High-Speed action)         Column Rename (High-Speed action)         Calculator (High-Speed action)         Filter Rows (High-Speed action)         Get Meta-Data         Sampling          
 

 
Cleaning
Change Data Type (High-Speed action)         Correct Spelling (High-Speed action)       Naïve Deduplicate (High-Speed action)         Replace String (High-Speed action)         Column Rename (High-Speed action)         Regular Expression Test (High-Speed action)         Accumulator         Table validate         Keep Only Duplicates         Drop First Rows         Pattern Extractor         Discretize Variables          
 

 
Data Mining
TIMi Use Models (High-Speed action)         Lift Curves (High-Speed action)         Confusion Matrix (High-Speed action)         Quantile (High-Speed action)         Vectorized Calculator (High-Speed action)         Covariance (High-Speed action)         Segmentation Model         Transaction-level to Customer-level Aggregation         Compute RSquare         Logarithm         Normalize         ROC Curve R action         KS Curve ( action)          
 

 
Graph mining

Graph Mining         Regular Expression Test (High-Speed action)         Node Analysis         Significance Level         Leadership         Infection         Merge CDRs         Pattern Extractor          
 

 

 
Text mining

Correct Spelling (High-Speed action)       Phonetic Encoding (High-Speed action)       Detect Language (High-Speed action)       Bag of Word (High-Speed action)       Google Translate (High-Speed action)         Rosette         E-Mails From Files       Read One File per Cell       Write One File per Cell       Cloud of words         Extract Surrounding Lines       Text Similarity         Regular Expression Test (High-Speed action)          
 

 
GIS - Geographical Information System
KNN         Geocode using Nominatim         Reverse Geocode using Nominatim         Geocode Addresses using Bing Maps       Compute the Traveling-time using Bing Maps       Compute Isochrones using Bing       Geocoding and Reverse Geocoding       Load Shape       Save and view Shapes       Reproject GIS       Geometry Info       Simplify GIS       Tesselate GIS       ConcaveHull GIS       Expand GIS       Convert GIS       Create GIS Grid        
 

 
R Visualization
Histogram ( action)         Aggregate & Histogram ( action)         Scatter Plot ( action)         Correlation Matrix ( action)         Correlation Matrix V2 ( action)         Self Organizing Maps for data visualization ( action)         A priori ( action)         Cloud of Words (R action)         Multi Dimensional Scaling (R action)         Correspondance Analysis (R action)         Waterfall Plot (R action)         Multiplot (R action)         Population Pyramid Plot ( action)         ROC Curve (R action)         KS Curve ( action)         Box Plot (R action)         R PieChart         R Plot Time Serie         ROC Curve R action        
 

 

R Predictive Analytics
 
 

Multivariate Outlier Detection (R action)         CART – Step 1 - Create one “deep” tree (R action)         CART – Step 2- Prune a “deep” tree (R action)         Neural Network & MultiNomial Logistic Prediction (R action)         Support Vector Machine (R action)         Naïve Bayes (R action)         XGBoost (R action)         GLM (R action)         CHAID (R action)         Cox Model (R action)         Interactive CART (R action)         C50 (R action)         ROC Curve R action         Discretize Variables        
 

 
R Discovery Analytics

PCA (R action)         Hierarchical Clustering (R action)         K-Means Clustering (R action)         K-Medoids Clustering (R action)         Model Clustering (R action)         Latent Class Analysis Clustering (R action)         DBSCAN Clustering (R action)         Bayesian Network (R action)         Self Organizing Maps for data visualization ( action)         Multi Dimensional Scaling (R action)         Box Plot (R action)         Correlation Matrix V2 ( action)         Correspondance Analysis (R action)        
 

 
R Scoring

Apply a R-Based predictive model (R action)         ROC Curve R action         Apply a R-Based PCA model (R action)         Apply a R-Based Segmentation model (R action)        
 

 
Python Various

PyLoad Excel File (Python action)         Multiclass Logistic Regression (Python action)         PyApply Model (Python action)         PyApply Timi Model (Python action)       Read Pickle (Python action)         Write Pickle (Python action)
 

 
Operational Research

Assignment Solver (High-Speed action)         Dataset Reduction (High-Speed action)         KNN         Geocode Addresses using Bing Maps       Compute the Traveling-time using Bing Maps        
 

 
Time Series

Aggregate on Columns (High-Speed action)         Smoothen rows (High-Speed action)         Sum on Rows         Rolling Sum on Dates         Time travel         Value Back in Time          
 

 
Stats

Student T-test         Stratified Sampling         Line Regression        
 

 
Formater

Change Data Type (High-Speed action)         Concat         Date/Time Formatter         Number Formatter         Split         MD5         Distribute         ReadPDF         wordExportation         Excel Exportation to PDF         Powerpoint Exportation to PDF         Convert between TimeZones         Square Split         Transform Birthday to Age            
 

   
Key Performance Indicators (KPI)

Rank by Partition         Rolling Sum on Dates         Value Back in Time         KPI        
 

   
Distributed Computations

Loop with Jenkins         Wait for the termination of Jenkins Jobs         Query Jenkins        
 

 
System Tools

Abort a Graph       Clean HD Cache Temp Dir       Run Processes       List Files       Loop Anatella Graphs       Loop Anatella Graphs Advanced         Upgrade to XLSX       Downgrade to XLS       Reorder Files per Day       Run Selected Pin       Down and Uploads       Multiple Down and Uploads       Distribute       Calling a generic REST api        
 

 
Cloud Services

Google Analytics       SalesForce Download       SalesForce Upload       Facebook       SharePoint Download (High-Speed action)       SharePoint Upload (High-Speed action)       Unlock Azure services       Google Translate (High-Speed action)         Publish to Tableau Server       Down and Uploads       Multiple Down and Uploads       Calling a generic REST api       Check VAT       List the Files inside a S3 bucket       Download Files from a S3 bucket       Upload Files to a S3 bucket       Delete Files stored in a S3 bucket       List S3 buckets       Unlock Google Services       List the files on a GDrive       Download files from a GDrive       Upload local files to a GDrive       Delete files stored on a GDrive       List the files on a Google Cloud Storage       Download files from a Google Cloud Storage       Upload files to a Google Cloud Storage       Delete files from a Google Cloud Storage       List the buckets on a Google Cloud Storage       Download/Query a table on Google Big Query       Upload a table to Google BigQuery       Azure Storage List Files       Azure Storage Download Files       Azure Storage Upload Files       Azure Storage Delete Files       Azure Storage List Containers       OneDrive List Files       OneDrive Download Files       OneDrive Upload Files       OneDrive Delete Files       clip0827b       clip0843b       clip0845b       clip0847b       clip0849b       Unlocks ZohoCRM       Download data from Zoho CRM       clip0853b       clip0860b       clip0863b       clip0866b       clip0869b       clip0872b       clip0881b       clip0884b       clip0886b       clip0889b       clip0898b       Get data from Microsoft Dynamics CRM       Send data to Microsoft Dynamics CRM       OVH Cloud Object Storage List Files       OVH Cloud Object Storage Download Files       OVH Cloud Object Storage Upload Files       OVH Cloud Object Storage Delete Files       OVH Cloud Object Storage List Containers       Get Emails from GMail       Send Emails using GMail       Download JSON documents from Elastic Search       Upload JSON documents to Elastic Search       Delete JSON documents from an Elastic Search Server       List all the Indexes on an Elastic Search Server       List the File on a Mailbox org drive       Download Files from a Mailbox org drive       Upload Files to a Mailbox org drive       Delete Files on a Mailbox org drive       Download logs from a Splunk Server       Upload logs to a Splunk Server       Download JSON from a MongoDB Server       Upload JSON documents to a MongoDB Server       Download data from a Neo4JServer       List ressources on a Jira server       Retrieve the results of a JQL query running on a Jira server       List jobs in Jenkins       Download logs from Jenkins       Download data from SuiteCRM       Upload data to SuiteCRM       Delete data on a SuiteCRM server       Get Data from Supermetrics       Google Ads       List Surveys from Survey Monkey       Download Responses from Survey Monkey       PowerBI Upload       Download from Hubspot       Upload data to Hubspot       DropBox unlock       Dropbox List Files       Dropbox Download Files       Dropbox Upload Files       Dropbox Delete Files       Azure Manage Contacts       PhantomBuster Extraction       DropContact Extraction       Bouncer Validation       ChatGPT query        
 

   
Transformation Actions - Data Engineering

Historized Slowly Changing Dimensions       RedShift Bulk Upload through a S3 Bucket       SnowFlake Bulk Upload through an Azure Storage       SnowFlake Bulk Upload through a S3 Bucket  
 

 
Other Transformation Actions (TA)

Encrypt (High-Speed action)       File List from Observation Date       Bulk Encryption of a large quantity of Anatella Files       Auto unflatten       Transpose       Extract New Column Names       Column Names for DB        
 

 
Deprecated Transformations

Template       Join (High-Speed action)         Collate         Append (High-Speed action)         Column Filter       Filter Rows (High-Speed action)         Regular Expression Test (High-Speed action)         Smoothen rows (High-Speed action)         Aggregate on Columns (High-Speed action)         Time travel         Calculator (High-Speed action)         Transform Birthday to Age         Naïve Deduplicate (High-Speed action)         Flatten (High-Speed action)         Unflatten (High-Speed action)         Drop First Rows         Merge CDRs         Date/Time Formatter             Split         Distribute         Covariance (High-Speed action)         Accumulator         CART – Step 2- Prune a “deep” tree (R action)         Histogram ( action)         Aggregate & Histogram ( action)         PyGoogle Analytics (Python action)        
 

 
Output Actions

CSV file writer       Anatella “Gel file” writer       Generic ODBC Writer       Create Table       Export to Kibella       SQLite Writer       Send E-Mails       Send SMS with SMPP protocol (to a SMSC server)       Send SMS with HTTP protocol (to a SMS Gateway)       TCP-IP Send table       Streaming data processing using an HTTP source/sink       MQTT Publish (IoT connector)       Anatella “Columnar Gel” file writer (column based)       Outlook Send       Create Tableau Hyper File (.hyper) or Tableau Data Extract (.tde) file       Write Qlikview QVX       Teradata Writer       MS-Office-Charts Report Writer       Excel file Writer       XML File Writer       JSON File Writer       Write Parquet File       Write in Docx and Pptx       Write Tables in Docx       Generic OleDB writer       Postgres Writer       Oracle writer        
 

 

 

This section contains the following sub-sections:

 

5.1. General Parameters used in many actions

5.2. Input Actions

5.3. Run Control

5.4. Join Tables

5.5. Standard

5.6. Cleaning

5.7. Data Mining

5.8. Graph Mining

5.9. Text Mining
5.10. TA - GIS - Geographical Information System

5.11. TA - R Visualization

5.12. TA - R Predictive

5.13. TA - R_Discovery Analytics

5.14. TA - R Scoring

5.15. Python Various

5.16. Operational Research

5.17. Time Series

5.18. Stats

5.19. Formatters

5.20. Key Performance Indicators

5.21. System Tools

5.22. Distributed Computations

5.23. Cloud services
5.24. Transformation Actions - Data Engineering

5.25. Other Transformations Actions

5.26. User-Deprecated Transformations

5.27. Output Actions