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