How to read each column of each row with conditions?

[Egzon_BERISHA]

Hi there,
I have an Excel file and I want to retrieve the Header Text if its value is “Y”

Here is a snippet of my workflow

OUTPUT: Returns all the headers

WANTED BEHAVIOR: Return only the Headers that have for value an “Y”

Here is a snippet of my Excel file

[ppr (Peter)]

inside the for each (when looping the columns) you can insert an if Activity

COndition: row(item.ColumnName).toString().Trim().Equals(“Y”)
Then : log message - item.ColumnName

so it will loop over all rows, then over all cols and checks for the Y

Give a try

[Egzon_BERISHA]

@ppr

item.ColumnName

I tried but it is throwing this error:

[ppr (Peter)]

check for the . (dot) before Equals

[Egzon_BERISHA]

@ppr

row(item.ColumnName).toString().Trim().Equals(“Y”)

New error check my previous image I updated it

[ppr (Peter)]

Ensure that the typeargument of the for each is set to DataColumn

[Egzon_BERISHA]

Thank you wherry much man, you just helped me go thought a really taught obstacle, RESPECT