如何从List转移并获得总数 [英] How to pivot and get total from List

问题描述

你好，

我在C＃中有一个列表，现在我希望通过名称和按名称和日期来获得一个运行总计。

我的列表如下：

[0]

           
计数= 3

           
HeaderDate ="Monday 9/1/2018"

         ;   
ExtName ="101 - John Doe"

           ;  
Extension ="101"

<跨度风格=" 保证金：0像素">&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;
名称="John Doe"

<跨度风格=" 保证金：0像素">&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;
日期="9/1/2018"

[1]

    &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
计数= 1

           
HeaderDate ="星期二9/2/2018"

         ;&NBSP;&NBSP;&NBSP;
ExtName ="101 - John Doe"

           ;&NBSP;&NBSP;
Extension ="101"

<跨度风格=" 保证金：0像素">&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;
名称="John Doe"

<跨度风格=" 保证金：0像素">&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;
日期="9/2/2018"

[2]

    &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;
计数= 2

           
HeaderDate ="Monday 9/1/2018"

         ;&NBSP;&NBSP;&NBSP;
ExtName ="102 - Jane Doe"

           ;&NBSP;&NBSP;
Extension ="102"

<跨度风格=" 保证金：0像素">&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP; &NBSP;
姓名="Jane Doe"

<跨度风格=" 保证金：0像素">&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP ;&NBSP;
日期="9/1/2018"

结果如下：

< p style ="margin-bottom：9.0pt"> 名称	Monday 9 / 1/208	星期二9/2/2018	总计
101 - John Doe	3	1	4
102 - Jane Doe	1		1

 感谢您提供任何帮助。

KSS

 

 

---

keith

解决方案

您好，

您没有指明需要解决方案的语言。

对我而言，它看起来像SQL转换任务。  

祝你好运，

Andrey

Hello,

I have a list in C# that now I want to get a running total by Name and pivot by Name and date.

My list is like:

[0]

            Count = 3

            HeaderDate = "Monday 9/1/2018"

            ExtName = "101 – John Doe"

            Extension = "101"

            Name = "John Doe"

            Date = "9/1/2018"

[1]

            Count = 1

            HeaderDate = "Tuesday 9/2/2018"

            ExtName = "101 – John Doe"

            Extension = "101"

            Name = "John Doe"

            Date = "9/2/2018"

[2]

            Count = 2

            HeaderDate = "Monday 9/1/2018"

            ExtName = "102 – Jane Doe"

            Extension = "102"

            Name = "Jane Doe"

            Date = "9/1/2018"

Results would look like:

Name	Monday 9/1/208	Tuesday 9/2/2018	Total
101 - John Doe	3	1	4
102 – Jane Doe	1		1

 Thanks for any help on this.

KSS

 

 

---

keith

解决方案

Hello,

You didn't indicate a language in which you need a solution.

For me it looks like SQL Transform task. 

Best regards,

Andrey

这篇关于如何从List转移并获得总数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！