I have noticed that many work with data tables in our daily automation activities. However tasks like aggregating the data in a data table, Sorting the columns of a data table require some coding. How about easing it out with a simple set of activities…
I just got a component published which can do such tasks using a simple activity without the need of complex code in your workflows.
With every update, this component will be included with new activities that ease out complex data table related manipulations. As the initial version, this activity pack includes three activities.
- Data Table Consolidate: Enables to easily perform data grouping and calculating SUM, AVG, MIN, MAX, COUNT, STANDARD DEVIATION AND VARIANCE of the figures
- Data Table Column Sort: We can easily sort the data of a data table. However, ordering the columns of a data table is bit of a hassle. This activity helps ordering the columns in ascending or descending order of the column name with ease.
- Data Table Horizontal Merge: Combines the columns of two data tables with minimum joining capabilities. However, specifying a match column is mandatory. Though the data in it will not be matching, it will combine the two tables as one and the data will be arranged based on how it is matched.
it also includes a user manual where you can read and understand how to use the activities…
More activities will be added to this component in the future… Stay tuned…