| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
| transformations:start [2019/04/29 19:04] – [Import] dmitry | transformations:start [2019/04/29 19:15] – [Export] dmitry |
|---|
| * [[transformations:regexp|Regular expression]] - Create a new column with regular expression matches. | * [[transformations:regexp|Regular expression]] - Create a new column with regular expression matches. |
| * [[transformations:removeemptycolumns|Remove empty columns]] - Remove columns where all values are the same or empty. | * [[transformations:removeemptycolumns|Remove empty columns]] - Remove columns where all values are the same or empty. |
| | * [[transformations:removeemptyrows|Remove empty rows]] - Remove rows where all values are empty or whitespace. |
| * [[transformations:lookuprename|Rename columns with lookup]] - Rename multiple columns using a lookup table. | * [[transformations:lookuprename|Rename columns with lookup]] - Rename multiple columns using a lookup table. |
| * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. | * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. |
| * [[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:export1010data|Export into 1010data]] - export into 1010data (experimental, not supported). |
| * [[transformations:exporttableau|Export into Tableau]] - export data into a Tableau Data Extract. | * [[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 a XML file. |
| |
| ==== Workflow / Internal ==== | ==== Workflow / Internal ==== |
| |
| ==== Workflow / External ==== | ==== Workflow / External ==== |
| | * [[transformations:amazoncommand|Amazon command]] - perform an AWS S3 command (e.g. upload/download a file). |
| * [[transformations:sqlcommand|Database command]] - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file). | * [[transformations:sqlcommand|Database command]] - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file). |
| * [[transformations:deletedbrows|Delete database rows]] - delete rows in a database table that satisfy query condition. | * [[transformations:deletedbrows|Delete database rows]] - delete rows in a database table that satisfy query condition. |
