How to handle empty values while extracting Data from Website

[Mamata_Shee (MS)]

I’m trying to extract data from website, when any column having no values then it’s taking next column’s value, how to handle empty values:

[adiijaiin (Aditya Jain)]

hi @Mamata_Shee

You need to check and confirm on your selectors, looks like, the selectors are not identified correctly.

[Mamata_Shee (MS)]

@adiijaiin Hi, kindly check this sheet, when there some value not present like ratings then it’s taking next column value:

[lrtetala (Lakshman Reddy)]

Hi @Mamata_Shee

After extracting the datatable use for each row in data table in that use If activity
String.IsNullOrEmpty(CurrentRow(“OtherDetails”).ToString)

[Praveen_Mudhiraj]

H! @Mamata_Shee

After extracting the data you can use the for each row in data table and check whether the column has numeric value or text

1. for example - take if condition and check this condition by passing the column name
   = isNumeric(CurrentRow(0))
   if it contains numeric values then no need to anything keep the blank in then condition
   if it has text then you can do what ever like making the null or remove row value

for the reference please check the below screenshot!