Hello UiPath society,
I have problem with filtering the excel file with variables and have no idea how to resolve it.
The algorithm looks as following:
- I am getting text from website from specific field, which contains 5 digits ex. 99999, the output is called Segment1.
- Then I am assigning to new variable Segment1Str = Segment1.ToString
- I am doing similar situation with second specific field, and after getting text I am assigning new variable Segment2Str =Segment2.ToString
For this moment, Segment1Str and Segment2Str represents two parameters (strings) which potentially I want to apply as a filter in sequentially first and second column in opened excel file.
The next step is opening the Excel Application Scope and indicating the excel file and creating DataTableDT as output, basing on overall file. And here comes the thing - I need to find fields in DataTable, filtering with 2 parameters: filter on Segment1Str on A column and paralelly Segment2Str on B column. There will be only one record that meets the two obtained earlier paramters
My first question - how apply this filter in Excel filewith variable? Moreover I do not know how to apply two filters in one expression.
I have prepared this code, but it does not work:
and then do that again:
To be honest I am stucked. I will be gratefull if you could indicate me what I should do.
Thank you in advance!