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 Preuss)
2
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
I tried but it is throwing this error:
ppr
(Peter Preuss)
4
check for the . (dot) before Equals
New error check my previous image I updated it
ppr
(Peter Preuss)
6
Ensure that the typeargument of the for each is set to DataColumn
1 Like
Thank you wherry much man, you just helped me go thought a really taught obstacle, RESPECT
system
(system)
Closed
8
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.