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/04/29 19:20] dmitrytransformations:start [2019/12/07 12:31] – added 7 more actions dmitry
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.txt · Last modified: 2024/02/03 18:00 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki