Activity DescriptionPerforming 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 component 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<ul><li>Data Transpose: Similar to the Excel Transpose function. Provide a DataTable with data and it will transpose the data for you</li><li>Network Days: Provide the start date and end date along with the holidays that fall within the period defined by the two dates and it will generate the number of working days and hours (number of days * 24)</li><li>Custom Date Series: Similar to the WORKDAY.INTL function in Excel. Provides a custom list of days based on the date pattern provided.</li></ul>How it all worksHow it all works is described in the documentation attached. Please refer to it.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 component includes activities that can be used to perform such advanced data manipulations without the need of Excel

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.

UiPath MVP/ RPA Solution Architect

Will it exclude Saturday and Sunday at the time of calculating Network days or do we need to add those days also under Holiday list ?

Getting error. Not a valid nugkpg. Header file is corrupt.

it is showing an error : A local file header is corrupt

facing the same error: A local file header is corrupt.

I have manually placed this package in the folder where all other packages are present

I have downloaded nupkg file, Could you please help me to know how to use this with the project which I am working on?

I get this error when I try to use the Transpose Acitivity

Data Transpose: Critical error in transpose - Unique Column Transpose. Error Info: Input array is longer than the number of columns in this table. | Error Soure: System.Data | Error Trace:    at System.Data.DataTable.NewRecordFromArray(Object[] value)

   at System.Data.DataRowCollection.Add(Object[] values)

   at lambda_method(Closure , VB$AnonymousType_0`2 )

at System.Linq.Enumerable.<>c__DisplayClass7_0`3.<CombineSelectors>b__0(TSource x)

   at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()

   at System.Data.DataTableExtensions.LoadTableFromEnumerable[T](IEnumerable`1 source, DataTable table, Nullable`1 options, FillErrorEventHandler errorHandler)

   at System.Data.DataTableExtensions.CopyToDataTable[T](IEnumerable`1 source)

   at lambda_method(Closure , ActivityContext )

   at Microsoft.VisualBasic.Activities.VisualBasicValue`1.Execute(CodeActivityContext context)

   at System.Activities.CodeActivity`1.InternalExecuteInResolutionContext(CodeActivityContext context)

   at System.Activities.Runtime.ActivityExecutor.ExecuteInResolutionContext[T](ActivityInstance parentInstance, Activity`1 expressionActivity)

   at System.Activities.InArgument`1.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance activityInstance, ActivityExecutor executor)

   at System.Activities.RuntimeArgument.TryPopulateValue(LocationEnvironment targetEnvironment, ActivityInstance targetActivityInstance, ActivityExecutor executor, Object argumentValueOverride, Location resultLocation, Boolean skipFastPath)

   at System.Activities.ActivityInstance.InternalTryPopulateArgumentValueOrScheduleExpression(RuntimeArgument argument, Int32 nextArgumentIndex, ActivityExecutor executor, IDictionary`2 argumentValueOverrides, Location resultLocation, Boolean isDynamicUpdate)

   at System.Activities.ActivityInstance.ResolveArguments(ActivityExecutor executor, IDictionary`2 argumentValueOverrides, Location resultLocation, Int32 startIndex)

   at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

This happens when "IsFirstColumnDataUnique" is set to "True"

When I set "IsFirstColumnDataUnique" to "False", I get all generic column names "ColumnA", "ColumnB", etc. and then two rows

This package is currently broken and/or corrupted to some extent as I'm not even able to open it via NuGet Package Manager due to an error stating: "A Local header is corrupt.'.

I've tried clearing NuGet cache entirely, removing & re-installing the package, rebooting Studio & Robot Services, all to no success.

Having the same issue below. Lahiru can you please look into this because from screenshots I believe it will be a lot useful.

I used Data Transpose activity to transpose a datatable already populated by reading a sheet within an Excel file.

The datatable is composed by 207 rows and 37 columns.

After the transpose functionality I obtain 252 row and 28 columns.

Is it happening to someone else? Any suggestion or workaround?

Note to everyone, if you download the file manually and try to place it in your packages folder you will get the "local file header is corrupt" message.  To install properly go to "Manage Packages" in UiPath, click "All Packages" and search for "DataManipulations.Activities".  

Also getting the "input array is longer than the number of columns" error. I'd read the documentation file but can't find it.

 - Easy to use activity... quick feature to access data!!!


Data Manipulations

Data Manipulations

Help

How To