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         Geocoding & Reverse Geocoding         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          
 

 
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)          
 

 
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         ANATEL~3_img806         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)          
 

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

 

R Predictive Analytics
 
 

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

 
R Discovery Analytics

Box Plot (R action)         Correlation Matrix V2 ( action)         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)         Self Organizing Maps for data visualization ( action)         Bayesian Network (R action)         Correspondance Analysis (R action)         Multi Dimensional Scaling (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)         Generic ODBC Writer        
 

 
Python Various

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

 
Operational Research

Assignment Solver (High-Speed action)         KNN (High-Speed action)         Dataset Reduction (High-Speed action)        
 

 
Time Series

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

 
Stats

Student T-test         Stratified Sampling         Line Regression        
 

 
Formater

Change Data Type (High-Speed action)         MD5         Split         Distribute         Number Formatter         wordExportation         Transform Birthday to Age         Date/Time Formatter            
 

   
Key Performance Indicators (KPI)

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

   
Distributed Computations

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

 
System Tools

List Files       Loop Anatella Graphs       Loop Anatella Graphs Advanced       Down and Uploads       Multiple Down and Uploads       Distribute         Upgrade to XLSX       Calling a generic REST api       Reorder Files per Day       Delete Gel Files       Run Processes       wordExportation        
 

 
Cloud Services

Google Analytics       PowerBI Upload       SalesForce Download       SalesForce Upload       Facebook       SharePoint Download (High-Speed action)       SharePoint Upload (High-Speed action)       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       Geocode Addresses using Bing Maps       Compute the Traveling-time using Bing Maps        
 

 
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        
 

 
Depreciated 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 Doc          
 

 

 

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. R Visualization

5.11. R Predictive

5.12. R_Discovery Analytics

5.13. R Scoring

5.14. Python Various

5.15. Operational Research

5.16. Time Series

5.17. Stats

5.18. Formatters

5.19. Key Performance Indicators

5.20. System Tools

5.21. Distributed Computations

5.22. Cloud services

5.23. Other Transformations

5.24. User-Deprecated Transformations

5.25. Output Actions