Ignore null or empty spaces

Hi
I am running one process in which we need to lookup some values from different sheet
Initially reading the data from both the sheets and using Data look up activity under for each loop and write results back to excel in a separate column.
I am getting results perfectly (Checked in output panel) but when i am assigning the output value to assign activity i am getting an error

The error is because of some cell are white space or null, some cell has values to write, I just need to ignore the null or white spaces and proceed to the next row

Pls help me with this
Thanks in advance

If Activity - Condition:

isNothing(row(YourColNameOrIndex)) OrElse String.IsNullOrEmpty(row(YourColNameOrIndex).toString.Trim)

Thx @ppr

Now i am trying in different method like typing the excel formulas directly into the cell

=VLOOKUP(A2:A367,Sheet1!A2:A4,1,FALSE) in need to add char34 in order to get values in excel

Ps help
Thx

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