Data Discrepancy Excel- URGENT

Help Studio
, , , ,
1

As u can see in excel in 3rd row this value is not coming as per invoice value.
image

whereas in invoice 3rd row is having the value :

image
image756×620 82.8 KB 

Where could be the issue in code..?

@Srini84 @kumar.varun2 @GreenTea

2

Your Code is duplicating rows. 2nd, 4th, 6th, 8th and 10th rows are getting duplicated.

3

@mitul_choudhary

How are your extracting the line item to excel sheet, as we see there are duplicate rows which copies the previous row value

Thanks

4

@Srini84 @vikasrawat911
Yes, how can i identify it & sort it out…?

5

@Srini84 @vikasrawat911 @kumar.varun2

Please Suggest…!!

6

@mitul_choudhary

Can you share your workflow and project.json and example invoices you are working
because its difficult to say without seeing these

Thanks

7

How can i share it…?

8

@mitul_choudhary

You can zip your project folder and samples folder and send in a message to me if data is confidential

Thanks

10

Do one thing - you can get Distinct rows using -

dtInvoice = dtInvoice.DefaultView.ToTable(true, “Description”, “UnitPrice”)

If this solves your problem please mark it as solution.

11

Thanks where should i put it…?

12

One you have created your Excel, you can read the excel in a DataTable and then use the expression I provided and then output in a new Excel.