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
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
FilterDataTable.zip (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.
You can remove the unwanted columns by using filter activity
find attached flow for your ref
Report_Filter New.zip (15.9 KB)
Hope this helps
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.