Consolidated_LineItems_LINQ

Help Activities
, ,
1

Hi Expert,

I have an excel file with standard format and common headers with split of Rejected records and success records. And, it will be changing dynamically based on the number of line items. I need to consolidated with in a single table with both rejected and success records. Attached the sample input file and expected the output in the other sheet for your reference. How can achieve
Consolidated.xlsx (11.7 KB)
this by LINQ?

2

Hi @Balachander_Pandian

Can you try the below

This image depicts a sequence diagram of an automated process for handling and manipulating data within an Excel file using a series of defined actions such as finding, replacing, copying, appending, filtering, and writing data ranges. (Captioned by AI)
This image depicts a sequence diagram of an automated process for handling and manipulating data within an Excel file using a series of defined actions such as finding, replacing, copying, appending, filtering, and writing data ranges. (Captioned by AI)818×2488 204 KB

Sequence17.xaml (17.0 KB)

Output:

Consolidated.xlsx (13.2 KB)

Regards,

1 Like
3

@lrtetala Thank you very much

1 Like
4

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