How to extract multiple data from excel?

[sunain_chahar]

I have a Excel file which contains “Billing Document” and “GT Invoice number” , in some cases same billing document has different GT Invoice number so what can i do to create a logic that works for both scenarios with multiple and single invoice no.
i have provided the picture of excel file and the format in which i want output
Thanks for your help

[Dhanush_Naik]

Hi

Use filter data table activity
https://docs.uipath.com/activities/docs/filter-data-table

Regards,
Dhanush

[sunain_chahar]

can you explain the process

[Dhanush_Naik]

Hi

In value u can pass variable also

Regards,
Dhanush

[sunain_chahar]

Not working

[Rahul_Unnikrishnan]

Hello @sunain_chahar

Filter Datatable activity should work in your case.

First read excel and get the data to Datatable variable.

Then use filter Datatable activity and provide the required filtering expression. Then get the output to a new datatable variable.

[Dhanush_Naik]

Hi

Can you please share your workflow.

Regards,
Dhanush