Sub data table

Help Something Else
1

Good morning,
I need your help.
I have an excel file like the screenshot below.
I try to extract a sub data table filtered each time according to the chrono.
loop over “articles” to perform functionality and then write “done” infront of the columns treated with the same chrono
image

2

Hi @Dhouha_Cherif

Could you elaborate more then we can understand the query and try to give the better solution.

1 Like
3

Hi @Dhouha_Cherif ,
Can you share your expect output, I will code for you
I think filter data table will process success this problem
regards,
LNV

1 Like
4

Hello,
Thank you very much
For more details, for input i have excel file that contains two fondamental columns : chrono and article.
to start, I have to make a traversal of the excel file.
a processing will be carried out for the articles relating to the chrono. and then when this processing will be carried out the “done” status must be mentioned.
I tried to do something by myself but it is not working properly when more than one article belong to the chrono.

image
image456×509 8.7 KB

5

Hello,
Thank you very much
For more details, for input i have excel file that contains two fondamental columns : chrono and article.
to start, I have to make a traversal of the excel file.
a processing will be carried out for the articles relating to the chrono. and then when this processing will be carried out the “done” status must be mentioned.
I tried to do something by myself but it is not working properly when more than one article belong to the chrono.

image
image456×509 8.7 KB

6

we can group the data / split it to a list of datatables

Assign Activity:
TableList | DataType: List(Of DataTable) =

(From d in Your DataTable.AsEnumerable
Group d by k=d("num_chrono").toString.Trim into grp=Group
Select t = grp.CopyToDataTable).toList
1 Like
7

when marking any status for processing results we can do:

  • working against datatables and writing it back

And/Or

  • read range the excel
  • grouping it into a list( of list( of DataRow)) and keeping the reference to the origin datatable

And/Or

  • read range the excel
  • marking the datarows with an additional column and its rowindex / excel range
  • grouping and processing
  • using the marker column for the excel status cell update for the particular row
1 Like
9

Thank you very much
Very useful solution

10

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