Data Extraction for Specific data

Help Activities
, ,
1

image
image970Ă—630 20.3 KB

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!!!

2

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

3

@CHAN_Hiu_Fung_Victor_Stud

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

Cheers

1 Like
4

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

image
image832Ă—1571 73.3 KB

FilterDataTable.zip (95.3 KB)

5

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

6

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

7

image
image1168Ă—437 3.06 KB

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.

8

@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.

image
image1088Ă—808 30 KB

9

Hi @CHAN_Hiu_Fung_Victor_Stud

You can remove the unwanted columns by using filter activity

image
image869Ă—591 17 KB

find attached flow for your ref

Report_Filter New.zip (15.9 KB)

Hope this helps :slight_smile:

1 Like
10

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