Add columns in data table

[Sathish_Kumar_S]

@Yoichi

You have helped me in this post and all good. Thank you

Remove Duplicate row in Data table

@fernando_zuluaga @Yoichi Attached the input file for DT & expected output files . Kindly review the file and provide the solution… thanks Expectedoutput.xlsx (8.5 KB) Input-DT.xlsx (8.6 KB)

But now business wants to add document, Date, CurrentDate columns from inputsheet. I am not sure how to do that

Expected output

How do i add document,Date,current date in below code?

dt = dt.AsEnumerable.Where(Function(r) not String.IsNullOrEmpty(r(“Language”).ToString)).GroupBy(Function(r) r(“Key”).ToString).Select(Function(g) g.OrderByDescending(Function(r) arr.Contains(r(“Language”).ToString)).First).CopyToDataTable

Also document,Date,current date in this code?
dt = dt.AsEnumerable.Select(Function(r) dt.Clone.LoadDataRow({r(0),r(1),r(2),Cint(r(2))+2},False)).CopyToDataTable()

[Yoichi]

Hi,

Can you also share input sheet?

Regards,

[Sathish_Kumar_S]

newresult.xlsx (6.6 KB)

Thank you… Please find the input file for ModifyExtractedData.Xaml

ModifyExtractedData.xaml (9.6 KB)

Expected output:

[Yoichi]

Hi,

Can you try the following?

io_dtModifiedExtractedFile.Columns("NewRowNo").SetOrdinal(3)

io_dtModifiedExtractedFile = io_dtModifiedExtractedFile.AsEnumerable.Select(Function(r) io_dtModifiedExtractedFile.Clone.LoadDataRow({r(0),r(1),r(2),Cint(r(2))+2,r(4),r(5),r(6)},False)).CopyToDataTable()

Sample20230512-3.zip (15.3 KB)

Regards,

[Sathish_Kumar_S]

Thanks a lot