Data Extraction for Specific data

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

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

[rikulsilva (Henrique Lima)]

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

[Anil_G (Anil Gorthi)]

@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

[MFK (Faiz)]

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

FilterDataTable.zip (95.3 KB)

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

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

[AJ_Ask]

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

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

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.

[MFK (Faiz)]

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

[AJ_Ask]

Hi @CHAN_Hiu_Fung_Victor_Stud

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