Compare values in same column (filter DT)

Hello uipath comnrades,

I’m struggling yesterday with a basic filtering datatable issue. So, I have a column called “Category” which can only be of two values : either “filme” or “serie”, and within that if “filme” it will have to do one thing, if “serie” other thing.

My question is: using basic filtering datatable how can i compare to do a if?
~
example: if column “category”.Filme then X Else Y

Could you help me please? Thank you in Advance! I will let a print of the excel hereby.

@Margarida_Ferreira

  1. First use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say dtInput.

  2. And then use For Each Row activity to iterate one by one row.

        For Each row in dtInput
        IF row("Categoria").ToString.Trim.ToLower.Equals("filme")
        Then: do your action
         Else: do your action
    

Hello @Margarida_Ferreira ,

Please use the attached workflow. This will sovle your issue.
ActivityDemo.zip (2.0 MB)

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