Filter Column That Column Name Contain Key Word

Help Studio
, ,
1

Hi everyone,

I need to filter a datatable by its columns names.

Only columns that contain “NETPR” in the column name should remain. The other columns should be deleted. Anyone know how can I do that?

1 Like
2

@mazlumkacar

  1. Use Read Range activity to read the data from excel file and store output in inputDT.

  2. And then try below expression to filter the data from given DataTable.

         filterDT = inputDT.Select("ColumnName = 'NETPR'").CopyToDataTable

  3. And then use Write Range activity to write into Excel file and delete existing sheet.

3

Hello @mazlumkacar,
You can do something similar to below image: (Please change DataType for “item” variable.

image
image1322×702 22.4 KB

3 Likes
4

Thanks a lot @Bhavik_Solanki. But should i create a variable named “ColumnName” for this process?

Because i have no a spesific column name in this process. I need to remove those columns by its name.

5

@mazlumkacar , No you don’t have to. It is in-build property of DataColumn. As I mentioned in my previous post don’t forget to change the DataType of the “item” variable.

6

Here is screenshot for your reference. Click on For Each activity and update value.

image
image1306×631 20.2 KB

1 Like
7

Thanks again @Bhavik_Solanki . But i am getting this error when i try to do this.

image
image1455×609 30.7 KB

8

@mazlumkacar
Sorry for the late response. There is minor correction in above workflow. in For Each Activity, just replace “dt_httpresult.Columns” with “dt_httpresult.Copy.Columns” and it should work.

1 Like
9

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