• Getting started with Rulex Platform
  • Datasets used in the manual
  • Formulas and functions
  • Factory
  • Rulex Platform Reference Documentation
Hide navigation
  • Factory
    • Rulex Factory Licences
    • Basic Concepts
      • Environments, Resources and Flows
      • Permissions in Rulex Factory
      • Overview on the Stage
      • Factory Terminology
    • Getting Started
      • Creating Environments in the Factory
      • Saved and Custom resources
      • Local Filesystem File Location
      • Setting up connections
        • Remote Filesystem Connection
        • Establishing Remote Connections
        • Establishing Connections to Databases
        • Saving a Repository Connection as a Resource
      • Creating Flows
        • Importing Flows
      • Checking the Validity of a Flow with the Flow Review Tool
        • Creating an Excel Validation File
        • Mapping Tasks to Categories
    • Importing Data into a Flow
      • Saving Sources for Import and Export tasks
      • Using a Custom Source in Import and Export Tasks
      • Importing Data from a Microsoft Excel file
      • Importing Data from a Text File
      • Importing Data from a Json File
      • Importing Data from an XML File
      • Importing Data from a Database
      • Creating datasets using the Empty Source task
      • Conditionally Importing Data from Databases
      • Importing Structures with Import from Task
    • Working with your data in the Factory
      • Datasets and Attributes
      • Task Overview
        • Task categories
        • Saving and Computing Tasks
        • Selecting Attributes in tasks
        • Searching Tasks
      • Exploring and Structuring Data
        • The Data Manager
          • Computing Formulas in the Data Manager
            • Common operators in Factory formulas
            • Example of formulas in the Data Manager
          • Formulas and Functions in the Factory
            • Arrays in the Factory
              • enum function in the Factory
              • fillDown function in the Factory
              • fillLinear function in the Factory
              • fillUp function in the Factory
              • integer function in the Factory
              • len function in the Factory
              • matchHeaders function in the Factory
              • nominal function in the Factory
              • perm function in the Factory
              • rank function in the Factory
              • shift Function in the Factory
            • Logical functions in the Factory
              • ifelse function in the Factory
              • isDate function in the Factory
              • isDatetime function in the Factory
              • isFloat function in the Factory
              • isInteger function in the Factory
              • isMonth function in the Factory
              • isQuarter function in the Factory
              • isTime function in the Factory
              • isType function in the Factory
              • isWeek function in the Factory
            • Statistical functions in the Factory
              • anovat and anovap functions in the Factory
              • argMax and argMin functions in the Factory
              • chisquare and chisquarep functions in the Factory
              • cohenk function in the Factory
              • count function in the Factory
              • countIf function in the Factory
              • covariance function in the Factory
              • cumMax and cumMin functions in the Factory
              • distinct function in the Factory
              • entropy function in the Factory
              • fact function in the Factory
              • Gini function in the Factory
              • interquartile function in the Factory
              • max and max2 functions in the Factory
              • maxyoudencut function in the Factory
              • mean function in the Factory
              • median function in the Factory
              • min and min2 functions in the Factory
              • mode function in the Factory
              • movMean function in the Factory
              • pearson function in the Factory
              • quantile function in the Factory
              • roc function in the Factory
              • standard deviation function in the Factory
              • variance function in the Factory
            • Math and Trigonometry functions in the Factory
              • abs function in the Factory
              • acos function in the Factory
              • acosh function in the Factory
              • asin function in the Factory
              • asinh function in the Factory
              • atan function in the Factory
              • atanh function in the Factory
              • baseConv function in the Factory
              • ceil function in the Factory
              • cos function in the Factory
              • cosh function in the Factory
              • cumProd function in the Factory
              • cumSum function in the Factory
              • exp function in the Factory
              • floor function in the Factory
              • isInteger function in the Math and Trigonometry functions of the Factory
              • log function in the Factory
              • log10 function in the Factory
              • prod function in the Factory
              • rand function in the Factory
              • randGauss function in the Factory
              • round function in the Factory
              • sign function in the Factory
              • sin function in the Factory
              • sinh function in the Factory
              • sqrt function in the Factory
              • sum function in the Factory
              • tan function in the Factory
              • tanh function in the Factory
            • Text functions in the Factory
              • charReplace function in the Factory
              • distance function in the Factory
              • find function in the Factory
              • head function in the Factory
              • isPrefix function in the Factory
              • isSuffix function in the Factory
              • isWord function in the Factory
              • numExt function in the Factory
              • pad function in the Factory
              • phonetic function in the Factory
              • prefix function in the Factory
              • replace function in the Factory
              • strip function in the Factory
              • suffix function in the Factory
              • tail function in the Factory
              • textConcat function in the Factory
              • textExtract function in the Factory
              • textFormat function in the Factory
              • textLen function in the Factory
              • textLower function in the Factory
              • textSort function in the Factory
              • textUpper function in the Factory
            • Date and Time functions in the Factory
              • addMonth function in the Factory
              • addQuarter function in the Factory
              • addWorkingDays function in the Factory
              • addYear function in the Factory
              • currDate function in the Factory
              • currDatetime function in the Factory
              • date function in the Factory
              • datetime function in the Factory
              • day function in the Factory
              • hour function in the Factory
              • isDate function in the Date and Time functions of the Factory
              • isDatetime function in the Date and Time functions of the Factory
              • isMonth function in the Date and Time functions of the Factory
              • isQuarter function in the Date and Time functions of the Factory
              • isTime function in the Date and Time functions of the Factory
              • isWeek function in the Date and Time functions of the Factory
              • minute function in the Factory
              • month function in the Factory
              • quarter function in the Factory
              • second function in the Factory
              • time function in the Factory
              • timeZone function in the Factory
              • week function in the Factory
              • weekDay function in the Factory
              • year function in the Factory
            • Graphs functions in the Factory
              • connComp function in the Factory
              • leaf function in the Factory
              • leafDistance function in the Factory
              • root function in the Factory
              • rootDistance function in the Factory
            • System functions in the Factory
              • currDate function in the System functions of the Factory
              • currDatetime function in the System functions of the Factory
              • hostName function in the Factory
              • ipAddress function in the Factory
              • timeZone function in the System functions of the Factory
            • Data functions in the Factory
              • cast Function in the Factory
              • catNames Function in the Factory
              • decideType function in the Factory
              • disc function in the Factory
              • discEqualFrequency function in the Factory
              • discEqualWidth function in the Factory
              • discretize function in the Factory
              • isAttribute function in the Factory
              • isFloat function in the Data functions of the Factory
              • isType function in the Data functions of the Factory
              • type function in the Factory
          • Plotting Data in the Data Manager
            • Configuring plot options in the Data Manager
            • Changing the layout of a plot in the Data Manager
            • Setting how a plot is displayed in the Data Manager
            • Modifying the attributes used in a plot in the Data Manager
            • Plots available in the Data Manager
              • Plotting Bar Plots in the Data Manager
              • Plotting Scatter Plots in the Data Manager
              • Plotting Curve Plots in the Data Manager
              • Plotting Heat Maps in the Data Manager
              • Plotting Pie Charts in the Data Manager
              • Plotting Stat Plots in the Data Manager
            • Updating Plots After Query Operations
          • Managing Attributes in the Data Manager
            • Managing Attribute Values
            • Advanced Attributes Management in the Attribute Tab
          • Querying Data in the Data Manager
            • Pre-filtering Data in the Data Manager
            • Building complex pre-filters and post-filters in the Factory
            • Grouping values in the Data Manager
            • Applying functions in the Data Manager
            • Sorting values in the Data Manager
            • Post-filtering Data in the Data Manager
          • Computing Statistics in the Sheets tab
            • Computing Single Statistics in the Sheets tab
            • Values, Frequencies and Quantiles in the Sheets tab
            • Computing Correlation and Covariance in the Sheets tab
            • Computing Cross Tabulation Statistics in the Sheets tab
            • Computing ROC Curves in the Sheets tab
            • Computing Test for Independent Samples in the Sheets tab
            • Computing Test for Paired Samples in the Sheets tab
          • Tracking operations in the History tab
        • Reshaping, Transforming and Cleaning Datasets
          • Cleaning Datasets
          • Discretizing Data
          • Identifying and Managing Outliers
          • Reshaping Datasets to Wide Format
          • Reshaping Datasets to Long Format
          • Transposing Data
          • Performing Moving Windows Statistics in Data
        • Splitting Data into Training and Test Sets
          • Splitting Data with the Split Data Task
          • Splitting Data with the Data Manager
        • Merging Datasets
          • Joining datasets
          • Concatenating datasets
        • Using External Scripts in Rulex
          • Applying R Scripts in Rulex Flows
          • Applying Python Scripts in Rulex Flows
          • Importing Data from R Scripts
          • Importing Data from Python Scripts
        • Identifying the Principal Components in Datasets with PCA
      • Solving your problem
        • Solving Optimization Problems
          • Using Mixed Integer Linear Programming to solve Optimization Problems
          • Using Network Optimizer to solve Optimization Problems
          • Using Transport Optimizer to Solve Optimization Problems
        • Solving Supervised Learning Problems
          • Using SVM to solve Classification Problems
          • Using Decision Tree to solve Classification Problems
          • Using Auto Regressive to solve Regression Problems
          • Using K-Nearest Neighbor to solve Regression Problems
          • Using K-Nearest Neighbor to solve Classification Problems
          • Using Neural Networks to solve Classification Problems
          • Using Neural Networks to solve Regression Problems
          • Using Regression Tree to solve Regression Problems
          • Using Regression SVM to solve Regression Problems
          • Using Linear to solve Regression Problems
          • Using LLM to solve One-Class Problems
          • Using LLM to solve Classification Problems
          • Using LLM to solve Regression Problems
          • Using Logistic to solve Classification Problems
        • Solving Unsupervised Learning Problems
          • Solving Association Problems in the Factory
            • Using Anomaly Detection to solve Association Problems
            • Using Frequent Itemsets Mining to solve Association Problems
            • Using Hierarchical Basket Analysis to solve Association Problems
            • Using Sequence Analysis to solve Association Problems
            • Using Assortment Optimizer to solve Association Problems
            • Using Similar Items Detector to solve Association Problems
          • Solving Clustering Problems in the Factory
            • Using Label Clustering to Cluster Data
            • Using Projection Clustering to Cluster Data
            • Using Standard Clustering to Cluster Data
      • Working with the Results
        • Converting Structures
          • Converting Rulesets to Datasets
          • Converting Datasets to Structures
          • Converting Models to Datasets
          • Converting Structures to Datasets
          • Converting Datasets to Models
          • Converting Datasets to Rulesets
        • Analyzing and Optimizing Results
          • Analyzing Rules in the Rule Manager
          • Adding Rules Manually in the Rule Manager
          • Analyzing Frequent Itemsets and Sequences
          • Optimizing Association and Replacement Rules
          • Ranking Rule Features and Values
          • Analyzing Model Performance in the Confusion Matrix
          • Analyzing Classification LLM Rules in the Rule Viewer
          • Merging Rules
          • Applying Models to Data
          • Finding and Replacing Values in Datasets
          • Optimizing Rulesets
      • Compacting Tasks into Modules
        • Creating Modules without Data Sources
        • Configuring Modules without Data Sources
        • Creating Modules with Data Sources
        • Configuring Modules with Data Sources
        • Extracting Modules
      • Refining and Improving Flows
        • Selecting parts of a Flow with Select Flow
        • Enriching Flows using Widgets
        • The Flow Summary
          • Using the Summary
            • Setting the parametric options in the Option Manager
          • Using Variables in the Factory
            • Using the Environment Variables
            • Using the Code Variables
            • Using the Vault Variables
          • Using Alerts in the Factory
          • Prioritizing Tasks in the Factory
          • Creating Documentation in the Factory
        • Configuring Runtime Variables
        • Managing Parametric Options in Tasks
        • Recording Macros
        • Working with Macros
          • Saving Macros
          • Using Macros in Events
        • Analyzing Flow Performance
      • Exporting Flows
        • Exporting Flows by Task
      • Exporting Data from a Flow
        • Exporting to a Database
        • Exporting to an Excel File
        • Exporting to a Json File
        • Exporting to a Text File
        • Exporting to an Xml File
        • Exporting Data from the Data Manager
      • Modifying Flows Execution Preferences
Show navigation

Working with Macros

Not available in Factory Lite and Factory Personal licenses.

Once a macro is created, you can start working with them. In this section, you will find information on:

  • Saving Macros
  • Using Macros in Events

Search

    Powered by Instant Websites for Confluence