Issue while saving the get text values to datatable

[Bhagyashree_S]

Hi,

I have saved the get text values into datatable by using
Read range,build data table ,add data row and then write range.

All the values are saving but it’s taking first row as empty value .how to remove the first row as empty so that the data should add to it.

[vrdabberu (Varunraj Dabberu)]

Hi @Bhagyashree_S

Please check in the build data table activity if you have left any first row as empty.

Regards

[vrdabberu (Varunraj Dabberu)]

HI @Bhagyashree_S

1st row in Data Table is empty

@Cardon_Cezar Are you using Build DataTable activity to create new DataTable ? If yes then I guess you added two empty rows in it and because of that it’s adding empty row. Please keep one Empty row and delete rest of empty rows.

Regards

[rlgandu (Rajyalakshmi Gandu)]

@Bhagyashree_S

In your build datatable you have to remove these rows

[pravallikapaluri]

Hi @Bhagyashree_S

YourDataTable = YourDataTable.AsEnumerable().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable()

[Bhagyashree_S]

Hi ,

I have removed the extra row and now I am able to see the 3 values one by one .

And I am comparing these values with another values.
But here in my case while comparing it’s comparing the only last row value with all the values.its not comparing with each row

[vrdabberu (Varunraj Dabberu)]

Hi @Bhagyashree_S

If you have another query please post a new topic.

Regards