Filter datable

Hi All ,

I have the first table how I can filter data and create dynamically process to create the table 2

Thanks

Hi,

Hope the following sample helps you.

Sample20201115-2.zip (9.6 KB)

P.S. Should value of Feb-Since be 3?( not Jan-Since)

Regards,

1 Like

@Yoichi
Thanks I will see

P.S. Should value of Feb-Since be 3?( not Jan-Since)

yes correct sorry for the mistake

@Yoichi Thank you so much , it is work fine :grinning:

1 Like

@Yoichi Could you please explain to me the process ?
Thanks

Hi,

The above sample is roughly as follows:

  1. Read src table as DataTable using Read range activity

  2. Get non-dupulicated subject list from the datatable using LINQ Select method and Distinct method.

  3. Create datatable for storing result table. Columns of the table are “Month” and items of subject list.

  4. Get non-dupulicated month list from the source datatable using LINQ Select method and Distinct method.

  5. Iterate each row of source datatable. (the following #6-#7)

  6. Get index number of result datatable which is same as the row(“Month”) of src datatable.

  7. If index number is non-negative, assign the value (row(“Number of studies”) of src datatable) to the row(MonthName) of result datatable.
    if index number is negative , create new row to result datatable and assign value.

Regards,

1 Like

@Yoichi Thanks

1 Like

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