Issue in extracting single column from entire datatable

Help Studio
, ,
1

Hi,

Good day

I have extracted datatable using datascapping. below is the sample output file.
forum

In this i need to extract only 2 column values

the option i know is by using filter datatable avtivity we can do but what is the column name i have to give in output columns(Filter datatable activity)

i have to get only column 2 output values in a final datatable without empty rows
output datatable column value shown below
123
5386
58768
65
659

Thanks
Likitha

2
  1. under filter rows tab set “Column-2” is not empty
    image
  2. under output columns tab set column = “Column-2”
    image

Alternative:
this will give you column-2 values (non empty) in a list
dt.asenumerable.where(function(row) not string.isnullOrEmpty(row("Column-2").toString)).select(function(row) row("Column-2").toString).ToList

1 Like