Both sides previous revisionPrevious revisionNext revision | Previous revision |
transformations:start [2024/04/11 20:36] – [Workflow / Apps and cloud] craigt | transformations:start [2024/04/12 00:30] (current) – [Import / File] craigt |
---|
* [[transformations:importjson|Import JSON from file]] - import JSON from a text file. | * [[transformations:importjson|Import JSON from file]] - import JSON from a text file. |
* [[transformations:importplaintext|Import plain text]] - import a text file as is without parsing. | * [[transformations:importplaintext|Import plain text]] - import a text file as is without parsing. |
* [[transformations:importqlikview|Import Qlik QVD file]] - import data from a QVD file. | * [[transformations:importqlikview|Import Qlik QVD file]] - import data or metadata 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: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:append|Append another table]] - Append another table as new rows or columns. | * [[transformations:append|Append another table]] - Append another table as new rows or columns. |
* [[transformations:addcolumn|Calculate new column(s)]] - calculate new column with [[syntax:start|expression]] built using arithmetical operations and various functions. | * [[transformations:addcolumn|Calculate new column(s)]] - calculate new column with [[syntax:start|expression]] built using arithmetical operations and various functions. |
* [[transformations:cleanup|Clean up]] - remove particular values from a column. | * [[transformations:cleanup|Clean up]] - remove particular values from one or more columns. |
* [[transformations:concatenatetext|Concatenate text]] - concatenate column values into delimited text. | * [[transformations:concatenatetext|Concatenate text]] - concatenate column values into delimited text. |
* [[transformations:convert|Convert data type]] - convert text dates into number dates. | * [[transformations:convert|Convert data type]] - convert text dates into number dates. |