Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2018/08/15 14:24] – [Export] dmitry | transformations:start [2019/04/29 19:05] – [Transform / Advanced] dmitry |
---|
* [[transformations:importfixedwidthtext|Import fixed width text file]] -import tabular data with fixed width columns from text file | * [[transformations:importfixedwidthtext|Import fixed width text file]] -import tabular data with fixed width columns from text file |
* [[transformations:importsql|Import from database]] - import data from a database | * [[transformations:importsql|Import from database]] - import data from a database |
| * [[transformations:importgooglesheet|Import Google Sheet]] - import data from a Google Sheet spreadsheet |
* [[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: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. |