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/04/29 23:20]
dmitry
transformations:start [2019/12/07 17:31] (current)
dmitry added 7 more actions
Line 12: Line 12:
   * [[transformations:​importqlikview|Import Qlik file]] - import data from a QVD file.   * [[transformations:​importqlikview|Import Qlik file]] - import data from a QVD file.
   * [[transformations:​importsas|Import SAS file]] - import data from a SAS file (.sas7bdat).   * [[transformations:​importsas|Import SAS file]] - import data from a SAS file (.sas7bdat).
 +  * [[transformations:​importsharepointlist|Import SharePoint list]] - import a SharePoint list.
   * [[transformations:​importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav).   * [[transformations:​importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav).
   * [[transformations:​importxml|Import XML file]] - import data from an XML file.   * [[transformations:​importxml|Import XML file]] - import data from an XML file.
Line 36: 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 49: 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 55: 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 82: 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 ====
Line 119: Line 132:
   * [[transformations:​googledrivecommand|Google Drive command]] - perform an operation with Google Drive, e.g. download a file.   * [[transformations:​googledrivecommand|Google Drive command]] - perform an operation with Google Drive, e.g. download a file.
   * [[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:​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:​runprogram|Run external program]] - execute external application once.   * [[transformations:​runprogram|Run external program]] - execute external application once.
   * [[transformations:​sendemail|Send email]] - send an email with attachment to one or more recipients.   * [[transformations:​sendemail|Send email]] - send an email with attachment to one or more recipients.
 +  * [[transformations:​sharepointcommand|SharePoint Command]] - transfer file(s) to/from SharePoint.
   * [[transformations:​sshcommand|SSH command]] - run one or several commands on a remote computer using the SSH protocol. ​   * [[transformations:​sshcommand|SSH command]] - run one or several commands on a remote computer using the SSH protocol. ​
   * [[transformations:​tableaucommand|Tableau Server command]] - trigger extract refresh on a Tableau Server.   * [[transformations:​tableaucommand|Tableau Server command]] - trigger extract refresh on a Tableau Server.
 +  * [[transformations:​webrequest|Web Request]] - send an HTTP request to a web API and receive a response.
   * [[transformations:​xslt|XSLT]] - transform given XML file using XSLT stylesheets.   * [[transformations:​xslt|XSLT]] - transform given XML file using XSLT stylesheets.
transformations/start.1556580000.txt.gz · Last modified: 2019/04/29 23:20 by dmitry