Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2023/11/24 21:10] – [Workflow / Apps and cloud] Add ChatGPT craigt | transformations:start [2024/02/03 17:51] – craigt |
---|
* [[transformations:importexcel|Import Excel spreadsheet]] - import data from Excel spreadsheets (.xls,.xlsx). | * [[transformations:importexcel|Import Excel spreadsheet]] - import data from Excel spreadsheets (.xls,.xlsx). |
* [[transformations:importfixedwidthtext|Import fixed width text]] - import tabular data with fixed width columns from text file. | * [[transformations:importfixedwidthtext|Import fixed width text]] - import tabular data with fixed width columns from text file. |
| * [[transformations:importapacheparquet|Import from Apache Parquet]] - import columns or metadata from an Apache Parquet file. |
* [[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:catalogcommand|Catalog command]] - list/create/update/delete Catalog directories, items, and item fields. | * [[transformations:catalogcommand|Catalog command]] - list/create/update/delete Catalog directories, items, and item fields. |
* [[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 conditions. |
* [[transformations:deletedbrowsbykeys|Delete matching database rows]] - delete rows in a database table where key values match/don't match key values in an EasyMorph table. | * [[transformations:deletedbrowsbykeys|Delete matching database rows]] - delete rows in a database table where key values match/don't match key values in an EasyMorph table. |
* [[transformations:downloadfile|Download file]] - download a file from the internet. | * [[transformations:downloadfile|Download file]] - download a file from the internet. |
| * [[transformations:emailcommand|Email command]] - performs various operations with email messages. |
* [[transformations:excelcommand|Excel command]] - perform file/sheet operations and run VBA macros in Excel files. | * [[transformations:excelcommand|Excel command]] - perform file/sheet operations and run VBA macros in Excel files. |
* [[transformations:fetchemail|Fetch email]] - fetch email messages and their attachments from a mail server (Exchange or IMAP). | * [[transformations:fetchemail|Fetch email]] - fetch email messages and their attachments from a mail server (Exchange or IMAP). |