Sign In
Create your first automation in just a few minutes.Try Studio Web →
DataTable Plugins
by YouTube
2
Activity
127
Hello Lahiru,
This is really very useful custom activity. I have a quick question. For Data Table Column Sort activity, I don't see any property where I can specify column name. I believe InputDataTable will accept DataTable variable and SortOrder will accept either "ASC" or "DESC" as input then where can we specify column name to sort? Also is it possible to specify more than one column to sort DataTable?
Regards
Hey, Lahiru! Just a quick question -
When using DataTableConsolidate, it seems to be outputting a datatable with the correct data, however the column locations have switched.
Input Columns: "SKU"|"QTY"|"Price"
Output Columns: "SKU"|"Price"|"QTY"
Is there a way to maintain the column location?
(Usage of activity below)
AggregateColumns:
{({"QTY", "Sum"})}
GroupByColumns:
{"SKU","Price"}
Hi Anthony,
Why the order got changed is because of the Group by column property.. In this activity, when it applies the group by operation, it brings together the columns that are used under group by property together in the order you specify. This actually allows us to see the columns that value is being group by in a single view which the aggregated values are on the right side next to those columns..
At the moment, this component doesn't support on getting the order back.. But, will be included in the new versions to come..
Thank you so much for reaching out and letting me your concern so that I can improve this..
Thanks
Lahiru
Hi Lahiru,
how to sum up if the column name has spaces.
I'm getting error.
for Example:
"Employee Name"
Hello Bahauddin
Currently, the activity does not support spaces in the column names. That is why you are getting the error. This will be addressed in the coming up new release of the activity. Thanks for mentioning it..
However, for you to get this to work, what you can do is, you can rename the column to replace the space with the underscore character ("_") using an assign activity.
DTName.Columns("Employee Name").ColumnName = "Employee_Name"
Now, pass this datatable to the activity and it will work like charm :)
Thank you and stay tuned for the new release during coming weeks
Hi Lahiru,
Will it sort data if column contains both mix of numbers and alphabets ?
Hi Lakshmnan
Yes it will sort even though it is numeric or alphabets and even when it is a mix of both..
how to use data table consolidate?
i think: GroupbyColumns(string[])should input: {"BOQ_number","COL_SALECODE.0"}
but AggregateColumns(string[][]) shoulod input?
BOQ_number |COL_SALECODE.0 | COL_ADD.0
abc |A | 4
abc |A | 5
need follow:
abc |A | 9
Hello Min Wang,
I'm sorry for my late reply on your question. For the AggregateColumns (String[][]), You have to provide the column which needs to be aggregated along with the aggregate function. So in your scenario here, it should be like
{({"COLL_ADD", "SUM"})}
License & Privacy
MIT
Privacy Terms
Technical
Version
1.1.5Updated
February 18, 2020Works with
This component is compatible with previous and current versions of UiPath Studio The component is built using .Net Framework 4.6.1 Component is tested using UiPath Studio 2019.6.0
Certification
Silver Certified
Support
UiPath Community Support
Resources
