Group By based on Task record no. and Find maximum date value

Hi All,

Please find the below screenshot and attached excel file. I want to find the maximum date by grouping Task Record number. Could you please help me in this.

report.xlsx (10.7 KB)

I want output like this:
21 86456 Revision of Hardness Limited 31-03-2020 reason
10 86457 Change Control Module… 19-04-2021 d

1 Like

Hi @lakshman,

Please check the example below and test the sequence called ‘Sequence’.

The only thing that I had to do with your report was to rename the columns and remove the spaces between them.

report.xlsx (11.2 KB)

ExtractWord.zip (12.2 KB)

2 Likes

Hi @acaciomelo,

I want below output:

21 86456 Revision of Hardness Limited 31-03-2020 reason
10 86457 Change Control Module… 19-04-2021 d

Hi @lakshman,

Have you tested it?

You will basically use the same activity that I used before.

Hi @acaciomelo,

Yes, I tested it and it is giving entire input data as output.

Hi @lakshman,

Please check this version:
ExtractWord.zip (21.6 KB)

1 Like

@acaciomelo,

Its working fine. Thanks a lot :grinning:

1 Like

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