¶ Description
New correlation matrix action.
¶ Parameters
¶ Parameters tab
Parameters:
- Input table partitioning (1st pin)
- Variables to analyze
- Chart title (and name of png)
- Correlation algorithm
- Lower matrix
- Upper matrix
- Variable order
- Relative font size
- Out: output type
¶ Description tab
Parameters:
- Script name
- Short description
- Revision
- Description
¶ Configuration tab
See dedicated page for more information.
¶ About
The R_CorrMatrix2 action button generates a correlation matrix plot using the corrplot R package. It computes pairwise correlations between selected numeric variables and visualizes the relationships using various plot styles (e.g., ellipse, number, pie, etc.).
¶ Example Input Table
| A | B | C | D | E |
|---|---|---|---|---|
| 1.1 | 2.3 | 4.5 | 3.2 | 5.0 |
| 0.9 | 2.1 | 4.3 | 3.0 | 5.1 |
| ... | ... | ... | ... | ... |
All variables must be numeric.
¶ Example Configuration
¶ Output
If idOutput = HTML document, you will get an .html file containing:
- Summary of missing values
- Correlation matrix plot
- Saved to
Recordsonly if properly configured in output ports
¶ Notes
- The correlation algorithm significantly affects the interpretation:
pearson: linear correlationkendall/spearman: rank-based
- Adjust
idxOrder = hclustto cluster similar variables. - Lower and upper matrix options support flexible styling for better readability.
- Preview mode may render output inline; full pipeline mode requires output file port exposure.
- If you see the error: Error: object 'HTMLf' not found, it means the
idOutput = chartmode is not implemented in the R script. Switch toHTML document.
¶ Troubleshooting
| Issue | Solution |
|---|---|
| Output file not found in records | Use HTML document only; ensure correct output port setup |
| "object 'HTMLf' not found" | Don't use chart output option |
| Blank preview or missing plot | Ensure all selected variables are numeric and contain no NA |
| Long run time or crash | Reduce data size; increase shared memory to 2 MB or more |
