Help with filters

[Anelisa_Bolosha]

GUYS help please…here i want to filter for only one column ‘Product Code’ and remove Campaign Code
How do i structure this line of code

[ppr (Peter Preuss)]

what exactly is not working. Mabye you elaborate more on this along with sample data

@Anelisa_Bolosha

remove

The LINQ Where operator is not for removing columns.

[HowTo] LINQ - First Start # Where Operator

This HowTo introduces how to use the Where operator. Introduction The Where operator is used for filtering. For the filtering, a condition is provided. All items matching this condition will pass the filter and will be part of the returned result. The condition has mandatory to return a boolean outcome. In other words: The result of the condition has to be True or False. Example IPO Samples Comment Values: 20,3,17,22,10,25,5 A collection of Numbers Filter Condition: x > 15 x is …

[Anelisa_Bolosha]

So I need to have an if statement where one uses to filter for both these columns on excel and the other needs to filter for only one which is ‘product code’.
So how do I use that function to filter for one column

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Anelisa_Bolosha ,
Can you share your data input and expectation output
Regards
LNV

[Anelisa_Bolosha]

Im using that enumerable.Where function

These are the two columns im using, so I need to filter for only product code columnn

[ppr (Peter Preuss)]

@Anelisa_Bolosha

So I need to have an if statement

lets link it with:

@ppr

Similar what e.g. is done within the UiPath IF Activity inside the Condition block in the same manner the filter condition can be provided to the LINQ

The lambda (evaluation expression) has to return a boolean indicating if the filter evaluation is met or not

[ppr (Peter Preuss)]

@tazunnisa.badavide

var filteredList

please name for us the resulting datatype of filteredList
Can you also show us where to find / how to set this specific datatype within the variable panel

Thanks

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi,
I understand here you have a list of products, a list of product codes, but you need to filter to get certain codes, for example “8200”.
you can use filter data table

you can try
Regards,
LNV

[Anelisa_Bolosha]

Everything is already working here like this but i just wanted a way to filter for one column if possible with that same function

[Mohammed_Ismail_Rahid]

dt.AsEnumerable()Where(Function(row) row.Field(Of String)(“productcode”)=desiredProductCode).ToArray()
try this…

[midori (QVinh)]

DT_MIP.AsEnumerable.Where(Function(x) x(“Product Code”) = ProductCode).ToArray()