Extract table using Filter data table

Learning & Development Programs Automation Starter
1

image
image1920×781 107 KB

hi everyone , i just want extract all data of column Product , MOQ , Selling…|How i can do it with filter data table . Thank you

2

Hi @hmduy

You can try with Linq expression

Use Read Range activity → store variable in DtRead

Use Assign activity

DtOut | Variavle Type → System.Data.DataTable

DtOut  = DtRead.DefaultView.ToTable(False,"Product","MOQ","Selling")

Note → “Product”,“MOQ”,“Selling” these three are column names so enter correctly

Regards
Gokul

3

Alternative method @hmduy

You can also try with Filter Data Table activity

image

Check out the link for more detail

Regards
Gokul

4

Hello @hmduy

After reading this excel you will get a datatable with all the columns. In order to keep only a few columns, use Filter Datatable activity. Enable Keep columns and select the Columns you need.
Then create a new output datatable.

In the new output datatable you will be able to find only the required columns.

Thanks

5

As img above , how can i read range from column Product to Selling column

6

Use Read range activity to read the excel file @hmduy

Share the sample excel file

7

Master.xlsx (28.8 KB)
I used Read range , but in the field “Range” , i want to read from left to right (B21 - H75) . What is the value i can input ?

8

Try like this in the Range

image

Regards
Gokul

9

Hi @hmduy

Check out the XAML file

image

FilterDataTableColumn.xaml (6.0 KB)

Output

Master.xlsx (29.0 KB)

Regards
Gokul

10

Thank your for your supporting guys . I extracted data successful . And now , how can i match data from pdf file with data extracted in Excel ! Please guild me detail <3

11

For the New requirement create new topic. Other user many confused

Kindly close this topic by mark as solved @hmduy

Regards
Gokul

1 Like
12

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