User Tools

Site Tools


transformations:start

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
transformations:start [2019/10/08 12:42] – [Workflow / External] dmitrytransformations:start [2020/06/29 09:02] – [Export] dmitry
Line 37: Line 37:
   * [[transformations:enumerate|Enumerate rows]] - add column with row numbers.   * [[transformations:enumerate|Enumerate rows]] - add column with row numbers.
   * [[transformations:lookup|Lookup]] - replace values in a column using a lookup table.   * [[transformations:lookup|Lookup]] - replace values in a column using a lookup table.
 +  * [[transformations:makedatetimecolumns|Make date/time columns]] - Create column(s) with date/time attributes derived from a date column.
   * [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match.   * [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match.
 +  * [[transformations:repeatrows|Repeat rows]] - repeat each row as many times as specified in given column.
   * [[transformations:replacecolumn|Modify column]] - replace existing column with a calculated [[syntax:start|expression]].   * [[transformations:replacecolumn|Modify column]] - replace existing column with a calculated [[syntax:start|expression]].
   * [[transformations:peek|Peek]] - create a new column using a single value from another table.   * [[transformations:peek|Peek]] - create a new column using a single value from another table.
Line 50: Line 52:
  
 ==== Transform / Advanced ==== ==== Transform / Advanced ====
 +  * [[transformations:constructjson|Construct JSON]] - Construct a JSON object.
 +  * [[transformations:createbuckets|Create buckets]] - Create ranges of fixed width and assign each row to one of the ranges.
   * [[transformations:crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.   * [[transformations:crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
 +  * [[transformations:enumerategroups|Enumerate Groups]] - Enumerate all combinations of values in given columns.
   * [[transformations:fillgaps|Fill down]] - Fill down empty cells.   * [[transformations:fillgaps|Fill down]] - Fill down empty cells.
   * [[transformations:fillright|Fill right]] - Fill empty cells to the right.   * [[transformations:fillright|Fill right]] - Fill empty cells to the right.
Line 56: Line 61:
   * [[transformations:group|Group]] - Assign a group name (or flag) to selected column values.   * [[transformations:group|Group]] - Assign a group name (or flag) to selected column values.
   * [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns.   * [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns.
 +  * [[transformations:iteratecolumns|Iterate columns]] - Iterate module/project by passing it columns one by one. Append the results back into one table.
   * [[transformations:labelcolumns|Label columns]] - Name columns using values from top rows.   * [[transformations:labelcolumns|Label columns]] - Name columns using values from top rows.
   * [[transformations:match|Match]] - Find text strings in another table, that are contained in the current table.   * [[transformations:match|Match]] - Find text strings in another table, that are contained in the current table.
 +  * [[transformations:parsejson|Parse JSON]] - Parse a JSON object into a tabular dataset.
   * [[transformations:pivot|Pivot]] - Create a matrix table by pivoting.   * [[transformations:pivot|Pivot]] - Create a matrix table by pivoting.
   * [[transformations:regexp|Regular expression]] - Create a new column with regular expression matches.   * [[transformations:regexp|Regular expression]] - Create a new column with regular expression matches.
Line 83: Line 90:
   * [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values.   * [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values.
   * [[transformations:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table.   * [[transformations:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table.
 +  * [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table.
   * [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table.   * [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table.
   * [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows.   * [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows.
   * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition.   * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition.
 +
 +==== Transform / Math ====
 +  * [[transformations:linearregression|Linear regression]] - Build a linear regression. Interpolate/extrapolate values if needed.
 +  * [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance.
  
 ==== Export ==== ==== Export ====
-  * [[transformations:exportdb|Export into database]] - export EasyMorph table into database table+  * [[transformations:exportdb|Export into database]] - export EasyMorph table into database table.
   * [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format.   * [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format.
   * [[transformations:exportexcel|Export into Excel spreadsheet]] - export data into an Excel spreadsheet.   * [[transformations:exportexcel|Export into Excel spreadsheet]] - export data into an Excel spreadsheet.
   * [[transformations:exportgooglesheets|Export into Google Sheets]] - export data into a Google Sheets spreadsheet.   * [[transformations:exportgooglesheets|Export into Google Sheets]] - export data into a Google Sheets spreadsheet.
   * [[transformations:exportdataset|Export dataset]] - export dataset into a file in the native EasyMorph data format (.dset).   * [[transformations:exportdataset|Export dataset]] - export dataset into a file in the native EasyMorph data format (.dset).
 +  * [[transformations:exportpowerbi|Export to Power BI dataset]] - export to Power BI push-dataset.
   * [[transformations:exportqlikview|Export into Qlik file]] - export data into a Qlik QVD file.   * [[transformations:exportqlikview|Export into Qlik file]] - export data into a Qlik QVD file.
-  * [[transformations:export1010data|Export into 1010data]] - export into 1010data (experimental, not supported). +  * [[transformations:exporttableau|Export into Tableau]] - export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online
-  * [[transformations:exporttableau|Export into Tableau]] - export data into a Tableau Data Extract or publish to Tableau Server. +  * [[transformations:exportxml|Export into XML file]] - export data into an XML file. 
-  * [[transformations:exportxml|Export into XML file]] - export data into XML file. +  * [[transformations:updatedb|Update database table]] - update a database table with values from EasyMorph.
 ==== Workflow / Internal ==== ==== Workflow / Internal ====
   * [[transformations:call|Call]] - pass table data to another project and run it once.   * [[transformations:call|Call]] - pass table data to another project and run it once.
   * [[transformations:either|Either table]] - between current table and another table choose one that is not empty.   * [[transformations:either|Either table]] - between current table and another table choose one that is not empty.
-  * [[transformations:halt|Halt on condition]] - stop project execution with an error if condition is TRUE for any row+  * [[transformations:halt|Halt on condition]] - stop project execution with an error if the specified condition is fulfilled
-  * [[transformations:iterate|Iterate]] - run another EasyMorph project once for each row in table. +  * [[transformations:iterate|Iterate]] - run another module/project once for each row in table. 
-  * [[transformations:iteratetable|Iterate table]]+  * [[transformations:iteratecolumns|Iterate columns]] - run another module/project once for each column in table and automatically append all returned columns into one table. 
 +  * [[transformations:iteratetable|Iterate table]] - run another module/project once for each row in table and pass another table to it. 
 +  * [[transformations:skiponcondition|Skip on condition]] - skip the rest of action in table if the specified condition is fulfilled.
   * [[transformations:status|Status]] - display custom project execution status message.   * [[transformations:status|Status]] - display custom project execution status message.
   * [[transformations:synchronize|Synchronize with another table]] - wait until another table is calculated.   * [[transformations:synchronize|Synchronize with another table]] - wait until another table is calculated.
transformations/start.txt · Last modified: 2024/02/03 18:00 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki