Skip null value

Hi Team,

I am creating one dt with column “Comments”

at start I have to check if that column contains something or not … if yes then proceed if not skip it.

thanks,

Hi @pankajmohan.dhane

Use If activity

Currentrow("Comments").Tostring.Trim.Contains("Something")

In then → You can skip he iteration

Regards
Gokul

@Gokul001 what if there is 0 rows ?

image

Use another if activity - It will check the row count in the DataTable

Dt.Rows.Count>=1

Regards
Gokul

If there are 0 rows then how could the column have a value?

it doesn’t… that is why wanted to skip with

@pankajmohan.dhane

You can’t able read the empty excel file without header or data. It will throw error while read it self.

So you can handle this using Try catch activity

Regards
Gokul

okay… thanks

If there are 0 rows the For Each Row just won’t do anything. You don’t have to do an extra check.

1 Like

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