Differences

This shows you the differences between two versions of the page.

--- transformations:intervalmerge [2025/01/27 15:13] – [Example #1] yurii
+++ transformations:intervalmerge [2026/09/22 08:13] (current) – [Action settings] added additional settings roberto
@@ Line 18: / Line 18: @@
 =====Action settings=====
 ^Setting^Description^
-|Merge table|Select the table to merge with the current dataset.|
+|Table to merge|Select the table to merge with the current dataset.|
-|Columns|Select whether to merge all columns in the second dataset, or just selected columns.  Options:  //All columns// or\\ //Selected columns// (choose which columns to include in the merge).|
+|Match condition|Define the interval: //Values in column// (a column in this table) //are greater or equal to// (a column with the lower boundaries in the other table) //and less than// (a column with the upper boundaries in the other table).|
-The reference to the second table will appear as a dotted line connecting this action to the second dataset in the application window.\\
+|Also match columns|Check this to also require that values in one or more pairs of columns are equal. Select a column in this table and the corresponding column in the other table; use //Add more matching columns// to add more pairs. A row is matched only if the paired columns are equal and the value falls into the interval.|
+|Columns to merge|Select the columns of the other table to add to the current dataset.|\\
 \\