cc4e1f9f-ee63-4465-ade4-76e04dcd5f13.png

Simplify and optimize the flow of structured data within your organization with the help of activities like data transformation, validation, comparisons. By automating these tasks, data can be streaml

Structured Data Streamlining

データ変換、検証、比較などのアクティビティを利用して、組織内の構造化データのフローを簡素化し、最適化します。これらのタスクを自動化することで、データを合理化、標準化し、アクセスしやすくすることができ、効率的なデータ分析、レポート作成、意思決定のプロセスにつながります。

自動化ツールと技術を活用して、大量のデータを管理および処理するための体系的なアプローチのメリットを活用します。手動作業を削減して

fab23a5f-5f0b-41fd-a29a-2567279b123d.jpg

UiPath MVP/ RPA Solution Architect

22723f58-a004-4165-8dfd-895eba43032c.nupkg

**Activity Description**

  

Performing advanced Excel functions without the use of Excel is quite hard. These functions are most of the time required by automation projects to handle different scenarios. This Data Manipulations package is an effort to ease out the hassle of using these advanced data manipulations within UiPath itself.

  

**Activities included - All these activities are independent and does not require Excel to run:**

*   **Data Transpose:** Similar to the Excel Transpose function. Provide a DataTable with data and it will transpose the data for you.
*   **Network Days:** Provide the start date and end date along with the holidays that fall within the period defined by the two dates. It will generate the number of working days and hours (number of days \* 24).
*   **Custom Date Series:** Similar to the WORKDAY.INTL function in Excel. Provides a custom list of days based on the date pattern provided.

**How it works**

How it all works is described in the documentation attached. Please refer to the Resources section.

  

This is the initial version of this component. There will be many more activities coming up in future versions. Stay tuned for more activities that ease out your automation.

Advanced Excel functions to manipulate data are quite hard to implement. This package includes activities that can be used to perform such advanced data manipulations without the need of Excel.

087eed9b-208d-4a66-bc36-c722384a4851.png

5a303eb6-448a-4915-93f4-9c2815bc433b.png

MIT License Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the 'Software'), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Version	Release Date	Download Link
1.0.6	July 2, 2019
Initial Release