Multiple Input Tables

Home » Multiple Input Tables » Page 3

Flexmonster Line

The ‘Flexmonster Line’ tasks is used to analyse big data sets in a pop-up graph quickly. If the input tables used contain a ZIPPYDOC formatting (refer to the Formatting Task), then the task tries to render a suitable graph design automatically. Otherwise, the user needs to manually select an intial design scheme for the pop-up graph. Please note that Flexmonster Graphs allow to easily modify the initial settings on the fly in the pop-up window. Attention: If you have blocked Pop-UPs in your browser, you need to unblock those to run this task. Go to Flow Gallery and Copy & Edit the Flexmonster...
Read more +

Flexmonster Bar

The ‘Flexmonster Bar’ tasks is used to analyse big data sets in a pop-up graph quickly. If the input tables used contain a ZIPPYDOC formatting (refer to the Formatting Task), then the task tries to render a suitable graph design automatically. Otherwise, the user needs to manually select an intial design scheme for the pop-up graph. Please note that Flexmonster Graphs allow to easily modify the initial settings on the fly in the pop-up window. Attention: If you have blocked Pop-UPs in your browser, you need to unblock those to run this task. Go to Flow Gallery and Copy & Edit the Flexmonster...
Read more +

Flexmonster Pivot

The ‘Flexmonster Pivot’ tasks is used to analyse big data sets in a pop-up pivot table quickly. If the input tables used contain a ZIPPYDOC formatting (refer to the Formatting Task), then the Pivot table tries to render a suitable pivot table automatically. Otherwise, the user needs to manually select columns, rows and values to design the pop-up graph. Please note that Flexmonster Graphs allow to easily modify the settings on the fly in the pop-up window. Attention: If you have blocked Pop-UPs in your browser, you need to unblock those to run this task. Go to Flow Gallery and Copy & Edit...
Read more +

Planning

The ‘Planning’ tasks renders a business plan with a very simple and new approach that becomes possible by big data management tools. Planning becomes much more accurate as it is now possible to plan each transaction in detail and not only plan aggregated numbers. This is not only very convenient for later comparison of plan to actuals, but also very convenient as it allows to render P&L, Cash-Flow and Balance Sheet by one click, as every transaction is actually included in the planning process. The Planning tasks revolutionalizes the speed of business planning and allows to plan with more accuracy and...
Read more +

Join Multiple

The ‘Join Multiple’ tasks automatically joins multiple input-tables. The join is performed as join by all columns with the same column name. The Join Multiple task is also very useful in searching for all tables with a specific table tag and joining all those tables together. Examples are distributed data sources, where e.g. one datasource contains Personell-ID and Personnel Name, the Other Personnel-ID and Salary and yet another table Personnel-ID and Holiday-Days. If those tables are tagged with the one tag, all those tables can easily be autojoined by this tasks. If more than one column exists for all the tables, having...
Read more +

Replace by Table

The ‘Replace by Table’ is working like the Find-Replace task. It extends, however, Find-Replace by not only finding value x and replacing this by value y, but finding one of the values x of a provided table and replacing this by a value y also provided in the find-replace table. The Find-Replace task is e.g. used to quickly translate substrings in a list by using a custom translation table. It is very powerful to automise translation tasks, where the translation service is providing the translation tables that are applied on the input lists. Go to Flow Gallery and Copy & Edit the...
Read more +

Auto-Fill

The ‘Auto-Fill’ task is used to populate a custom target table with the corresponding values of one or more source tables. The Auto-fill task is a very powerful task to automatically fill-in data in a target table. If you e.g. have various underlying tables and want to extract all values of a defined set of data, Auto-fill is most convenient to perform this task for you. Autofill has various options to extract data, e.g. as sum, list or more. Go to Flow Gallery and Copy & Edit the Auto-Fill Flow for example usecases.
Read more +

Create New Table

The ‘Create New Table’ task is used to create a new table in your flow. The Create New Table task is typically used to create an initial dummy table in the flow that is later replaced by a custom table. To replace a created dummy table by your custom table click on .../Paste From Clipboard. To rename the newly created table, click .../Update Table Info. Go to Flow Gallery and Copy & Edit the Create New Table Flow for example usecases.
Read more +

Popup

The ‘Popup’ task is used to launch a Popup Window with a D3 Graph based on a JSON-Input table. To import JSON datasets, the ZIPPYDOC plattform imports those in a standardized so called JSON table. This allows to apply all the powerful table wrangling tools to the JSON dataset. To import JSON code into a JSON dataset format, choose the select type  ‘JSON’ in the configuration option of your import task. The D3 Graph tools are very beautiful visualisations of e.g. tree like structures and allow to easily drill down in the stucture details. With Popup imported JSON datasets can easily be...
Read more +

Translate

The ‘Translate’ task us using the API provided by DEEPL (www.deepl.com), one of the leading translation services, to translate text of your table columns in another language. The Translate task is only avaibable for paying customers of the ZIPPYDOC plattform. With this task you can selectively translate specific columns of your tables. It also allows you to easily design an automised translation flow for data provided in one country that needs to be translated to another language prior to posting this data to another country. Go to Flow Gallery and Copy & Edit the Translate Flow for example usecases.
Read more +