Datatable Add Column Values based on row values

Help Something Else
1

16504550728149088201229830762676
165045507281490882012298307626761824×4000 433 KB

Can someone help me with the solution for this scenario.

2

the rule on how 3.6 is derived is not clear. May we ask you to resharp the requirements and their definitions

3

Sorry, it’s 2.6
Just addition of columns that are different.

4

still the same, the rules are not closed is any 0 blocking the group sums …?

Please start with complete case description. Thanks

5

16504558839832434490730321065982
165045588398324344907303210659821824×4000 424 KB

6

looks like a group by on column c1
then the group members will be sum up the col values when the col values are different

checking if the group member col val is different:
grp.Select(Function (x) x(ColNameOrIndex).toString.Trim).Distinct().Count = 1

7

I’m unable to put them together.

Can you provide the expression for this example.

8

@Vivek_Ananth
we can set it up within a hybrid approach balancing LINQ and essential actvities:

grafik
grafik889×921 79 KB

  • Grouping the data
  • Processing the groups
  • loping dedicated cols from the group member
  • checking if we do have same values or we will sum up

grafik

Find starter help here:
GroupyBy_1Col_SumColsWhenDifferent.xaml (14.1 KB)

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.