Hello All, My excel file contains number of records with mixed status if there is any failed status i have to display one failed record and exclude the remaining records

[Vamsikrishna_Talam]

I Have Record in excel file i have casenumbers and their status:

casenumber	statusid	Status
C31388906	3	Success
C31388906	3	Success
C31388906	4	Success
C31388906	3	Failed
i have to show only one record i mean if the casenumbers all are success i have to show only one success record if some records are failed i have to show only one failed record and have to remove the duplicate casenumbers and their status the output should be like the below:
casenumber	statusid	Status
—	—	—
C31388906	3	Failed
Can someone help me on this

[Yoichi]

Hi,

Can you try the following sample?

dtResult = dt.AsEnumerable.GroupBy(Function(r) r("casenumber").ToString).Select(Function(g) g.OrderBy(Function(r) keywordSuccess.Contains(r("Status").ToString)).First()).CopyToDataTable()

Sample20230125-6L.zip (2.9 KB)

Regards,

[Vamsikrishna_Talam]

hi @Yoichi thanks for your repsonse
Actually my process was in C# while using the above expression:
resultdata.AsEnumerable.GroupBy(Function(r) r(“casenumber”).ToString()).Select(Function(g) g.OrderBy(Function(r) keywordSuccess.Contains(r(“Status”).ToString())).First()).CopyToDataTable()

[Yoichi]

Hi,

Can you try the following?

dtResult = dt.AsEnumerable().GroupBy(r=> r["casenumber"].ToString()).Select(g=>g.OrderBy(r=>keywordSuccess.Contains(r["Status"].ToString())).First()).CopyToDataTable()

Sample20230125-6LCS.zip (3.0 KB)

Regards,

[Vamsikrishna_Talam]

@Yoichi Yes, i tried the expression in the above mentioned but facing the issue

[Yoichi]

Hi,

Can you share your current expression?

Regards,

[Vamsikrishna_Talam]

resultdata.AsEnumerable.GroupBy(Function(r) r(“casenumber”).ToString).Select(Function(g) g.OrderBy(Function(r) Keyword.Contains(r(“Status”).ToString)).First()).CopyToDataTable()

where resultdata is my excel data output
Keyword is my “Success”

[Yoichi]

Hi,

Can you check the above attached sample : Sample20230125-6LCS.zip (3.0 KB)
It includes C# code.

Regards,

[Vamsikrishna_Talam]

@Yoichi thank you for the help it’s working fine