Sorting data by first column name value and add 3 empty rows between them

[ldiaz (Leonardo Diaz)]

Input

expected output

i also want to make a sum in the end of each
i have column that have amount.

[ppr (Peter Preuss)]

One of many approaches is to group the data by the first column value
(Non-LINQ, LINQ Approach)

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…

[Umadevi_Sanjeevi]

Hi @ldiaz ,

Can you try this,

Input

Output

Sample xaml
SortData.xaml (12.1 KB)

[ldiaz (Leonardo Diaz)]

[ldiaz (Leonardo Diaz)]

your file works. but when i applied it in my workflow it shows this warning. i don’t know.

[ldiaz (Leonardo Diaz)]

it works now . not my problem is in the same column i have cell that contains (-) i can’t convert the column price because of if . can you help?

[Umadevi_Sanjeevi]

Hi @ldiaz

Can you share any screenshot?

Product1	-100
Product1	109
Product1	100

Price total will be 109

Working fine for me.

Can you explain your issue little elaborate.

Thanks!

[ldiaz (Leonardo Diaz)]

when this activity is enabled

uipath throws this error
Assign: Input string was not in a correct format.
Input string was not in a correct format.

[supermanPunch (Arpan)]

@ldiaz

not my problem is in the same column i have cell that contains (-) i can’t convert the column price

Hi @ldiaz ,

Could you show us the data containing that specific value which contains hyphen (-) ?

It might also be the case if there are empty values in the column. Do you have such values ?

[ldiaz (Leonardo Diaz)]

here sir

[supermanPunch (Arpan)]

@ldiaz ,

In that case, Could you check with the below Expression :

FilteredDT.AsEnumerable.Sum(Function(x)CDbl(if(x("Column Name").ToString.IsNumeric,x("Column Name").ToString,"0")))

[Umadevi_Sanjeevi]

Hi @ldiaz

Can you try this

filterDT.AsEnumerable.Sum(Function(x) if(IsNumeric(x(“Price”).ToString.Trim),CDbl(x(“Price”).ToString.Trim),0.0))

Thanks!

[ldiaz (Leonardo Diaz)]

@Umadevi_Sanjeevi

filterDT.AsEnumerable.Sum(Function(x) if(IsNumeric(x(“Price”).ToString.Trim),CDbl(x(“Price”).ToString.Trim),0.0))

hi . this works . thank you

[Umadevi_Sanjeevi]

Can you mark as Solution

[ldiaz (Leonardo Diaz)]

[Umadevi_Sanjeevi]

Can you check this xmal
SortData1.xaml (4.7 KB)

[Umadevi_Sanjeevi]

Hi @ldiaz ,

Apology for asking you have marked solution to your reply !

Could you mark solution to my post!

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Regards