I just want to take the names which have a value, like (B, C, E, and G).
How should I do it?
in Read range with in double quotes just give(“A3:A8”)
We have read column activity @claudiojody
Please check out this file, fill in the correct path for your excel
Main.xaml (4.9 KB)
Hope these steps could help you resolve this
— use excel application scope and pass the file path as input
— use read range activity and get the output with a variable of type datatable named outdt
— now use a for each row loop and pass the above variable outdt as input
— now use a if condition like this
If the above condition passes it will go to THEN part of if condition where we can get the Name like this in a write line activity
Or if the condition fails it will go to ELSE part where we can leave it empty
Simple isn’t it
Hope this would like help you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.