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 revision Previous revision
Next revision
Previous revision
transformations:start [2019/10/08 16:46]
dmitry
transformations:start [2020/06/29 13:03] (current)
dmitry [Workflow / External]
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:repeatrows|Repeat rows]] - repeat each row as many times as specified in given column.
Line 51: 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:enumerategroups|Enumerate Groups]] - Enumerate all combinations of values in given columns.
Line 58: 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 89: Line 94:
   * [[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.
Line 124: Line 135:
   * [[transformations:iterateprogram|Iterate external program]] - execute external application once for each row in table.   * [[transformations:iterateprogram|Iterate external program]] - execute external application once for each row in table.
   * [[transformations:iteratewebrequest|Iterate Web Request]] - send multiple uniform HTTP requests to a web API and append responses into one table.   * [[transformations:iteratewebrequest|Iterate Web Request]] - send multiple uniform HTTP requests to a web API and append responses into one table.
 +  * [[transformations:powerbicommand|Power BI Command]] - Trigger a Power BI action, such as refreshing a dataset.
   * [[transformations:powershell|PowerShell]] - executes one or more PowerShell statements.   * [[transformations:powershell|PowerShell]] - executes one or more PowerShell statements.
   * [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely.   * [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely.
transformations/start.1570553208.txt.gz · Last modified: 2019/10/08 16:46 by dmitry