Filter components from Table Connector

  • 52 Views
  • Last Post 3 weeks ago
pankaj.yadav@technobraingroup.com posted this 3 weeks ago

Hi,

I want to know about these components from Table Connector.

1. What is purpose of using "GetFilterData" component from Table Connector, What kind of filter we can apply there and how?.

2. If i want to use "FilterAndSort"  then what kind of expression we can pass to the Expression Port eg. VB.NET methods OR formulas etc..

Looking forward for your response.

Regards,

Pankaj

ShivaKumar posted this 3 weeks ago

 

Hi Pankaj,

 

"GetFilteredData" is a method available in Excel connector and not under Table connector. It is used to extract the filtered data from an Excel sheet.

 

"SetFilter" method can be used to filter the data based on the requirement. Sheet Name, Column Name, and Filter Value have to be provided as input. For example:

SheetName: Sheet1

ColumnName: G

FilterValue (can be a string or expression): > 123

 

"FilterAndSort" method is used to set a filter based on an expression. This also supports sorting of data in ascending or descending order.

For example:

Expression: Age > 18 and Age < 21

SortColumnName: Age

Order: Asc or Desc

 

Regards,

Shiva Kumar

 

Close