Extract, display and compare items from a Data Table

datatable
studio

#1

Hi,

I have extracted a Data Table with 2 columns - one has names and the other has ID’s. I would like to display the contents of Data Table. Then, I would like to compare the names in the Data Table one by one with a list of names in Excel sheet and find a match. If there is a match, it should be displayed.

When I try to display contents of Data Table, null value is returned. Please help me with this.


#2

Hi @BhargaviRajagopalan
If Dt.rows(“name”).tostring.null or empty
Then give Argvalue as false with assign
Else Condition give row(1).tostring
Or
Dt.rows(""). tostring.equals dt.rows("").tostring

Thanks
Ashwin.S


#3

Thanks @AshwinS2
This is working now.