If condition issue


#1

Hi Guys

I have created a sequence for reading the value from excel files. If one of the column is empty in excel it should skip the sequence and go to the starting step by increment the counter value (Assign activity).

Issue 1 faced : in If condition how to check for null value If name=“null” will work out or any other ways i should proceed.

Issue 2 faced : If name value is value it should skip the sequence and increment the counter value and proceed

Thanks
Kamesh


#2

To check null values, convert the values to string and check “”
row(“columnname”).ToString()=""


#3

You can use the String.IsNullOrWhiteSpace(CellValue) in an If statement

IF String.IsNullOrWhiteSpace(CellValue) THEN
Skip
For your Issue 2:
IF String.IsNullOrWhiteSpace(CellValue).equals(value) Then
Increment counter