Documentation

Home » Documentation

Table to JSON

The ‘Table to JSON’ task is converting ZIPPYDOC JSON-tables into standard JSON code. After converting ‘JSON code’ to a ‘JSON table’, the JSON code can be converted and modified very powerful by the table wrangling tools of ZIPPYDOC. After conversion of the JSON table, it can be converted back to code by the ‘Table to JSON’ task. Note, that import of JSON code is also supported as automatic import and conversion to JSON tables. Similary JSON tables can be exported back as JSON code. Go to Flow Gallery and Copy & Edit the Table to JSON Flow for example usecases.
Read more +

JSON to Table

The ‘JSON to Table’ task is converting JSON code in a ZIPPYDOC table format to apply the rich set of table wrangling tools on JSON code. After converting ‘JSON code’ to a ‘JSON table’, the JSON code can be converted and modified very powerful by the table wrangling tools of ZIPPYDOC. After conversion of the JSON table, it can be converted back to code by the ‘Table to JSON’ task. Note, that import of JSON code is also supported as automatic import and conversion to JSON tables. Similary JSON tables can be exported back as JSON code. Go to Flow Gallery and...
Read more +

Get Background info table

The ‘Get Background info table’ task is only available for sheets uploaded from Excel via the ZIPPYDOC for Excel Add-In. Excel sheets contain many background information like font format, background colour, cell frames and frame colour or the underlying function used for the respective cell. The task is used to get all this information for a selected table that has been uploaded from Excel. The task is especially useful to automise dataflows derived from Excel tables, where meta-information is needed like cell colour or underlying functions to identify or modify the respective cells. Go to Flow Gallery and Copy & Edit the...
Read more +

Get Table Structure

The ‘Get Table Structure’ task is used to get table information of a dataset. This is an example of the table information provided of a table only containing 1 row with text, whitespace and puctuation: Record Count Empty Records Distinct Records Only Numbers Only Characters Contains Characters Contains Whitespace Contains Punctuation Welcome to ZIPPYDOC 1 0 1 FALSE FALSE TRUE TRUE TRUE Go to Flow Gallery and Copy & Edit the Get Table Structure Flow for example usecases.
Read more +

Select Columns

The ‘Select Columns’ task is used to select a specific series of columns of a dataset. It also allows to rename columns, sort by columns or adjust the colum format. Go to Flow Gallery and Copy & Edit the Select Columns Flow for example usecases.
Read more +

Apply Format

The ‘Apply Format’ task is used to apply a formatting information on the data itself. Each dataset used in ZIPPYDOC can be formatted by the ‘Formatting’ task. This tasks supplements columns with the information of the formatting to be used to display the data. Example. If a record is ‘0.1’, then: the record is shown as ‘0.1’ if no format is provided the record is shown as ‘10%’ if no format % is provided with no digits the record is shown as ‘10.00%’ if format % is provided with two digits In none of these cases, the underlying record ‘0.1’ is changed. If,...
Read more +

Table Type

The ‘Table Type’ task is used to convert the ZIPPYDOC table into different table types. The standard table type of tables used on the ZIPPYDOC plattform is a list based table style with one header row followed by content rows. The standard table type (1x0) has one heading row, but no heading column. ZIPPYDOC, however, supports up to three header rows and up to three label columns (i.e. up to three leading columns that contain titles of the respective rows, not content) Note, that matrix style tables with one ore more label columns and multi-header tables are not yet supported by the...
Read more +

Expand List

The ‘Expand List’ task is used to expand records that contain comma-separated lists into one item per row and reverse. If a record e.g. contains a list ‘One, Two, Three’ the task converts this list into three rows containing ‘One’,‘Two’,‘Three’ reverse. The task is very convenient to wrangle with comma-separated data-lists, either by applying the rich set of table-tasks on the converted row-by-row table and convert back or download the row-by-row table to Excel, manually adjust the entries and convert them back into the original list format. Go to Flow Gallery and Copy & Edit the Expand List Flow for example usecases.
Read more +

Curve Composer

The ‘Curve Composer’ task is used to autogenerate data curves of known standard shapes. The curve is composed in two parts, a left and a right part. In the settings, the user specifies: The number of data points (called periods) The shape of the curve (flat, linear, standard distribution) Initial value (first data point) and End value (last data point) Maxim value Optional plateau Go to Flow Gallery and Copy & Edit the Curve Composer for example usecases.
Read more +

Convert to Text

The ‘Convert to Text’ task is used to convert text to tables. To convert a Text to a table the task expects a column that contains the to be converted text in each cell. This task is especially useful for automisation procedures on text based data. The transformation is done by splitting text into words and non-words. The resulting Word-by-Word table with a Word column and a Non-Word column is the ZIPPYDOC plattform standard to apply the rich set of data wrangling tools on text. It also adds a column where ‘x’ presents the location of the respective word in the...
Read more +