Data Extraction for Specific data

Hello guys. I want to ask If I want to extract the database on the report number I want, First I use the input dialog to get the report number I want, but now I just need the application number, ID and cost for the relevant report, so how can I tell the robot that only extract those data I want, but not extract all the relevant report data.

Thank you for you read!!!

You can use Filter DataTable activity and pass column Report Number = input Report Number

The result DataTable only contains rows that matches with the given Report Number


Apart from filter you can use look up excel or look up datatable activities which will give only application number and id of the report number that is looked up


1 Like

Hi @CHAN_Hiu_Fung_Victor_Stud,

You can use the LINQ to filter the DataTable. I have created a workflow with LINQ and FilterDataTable. Please test it and let me know if found this helpful.

LINQ : dt_Filter.AsEnumerable().Where(Function (row) row(“Report”).ToString.ToUpper.Trim.Equals(ReportNo)).CopyToDataTable (95.3 KB)

Sorry guys. Then how can I just get the column( item) for the specify report number and place it in other excel file

Can you put the screenshot of the expected report that you want with all the required field. & Unique filed by which you want to extract the data

For example, I just want to show the Application Number, Report Number, Client, and ID for report R003, how to specify the column that I want.

@CHAN_Hiu_Fung_Victor_Stud, you can add the column in “Output Columns” Wizard which you don’t want to include in a final output.

Hi @CHAN_Hiu_Fung_Victor_Stud

You can remove the unwanted columns by using filter activity

find attached flow for your ref

Report_Filter (15.9 KB)

Hope this helps :slight_smile:

1 Like

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