Studio- issue with filtering datatable

Help Studio
, , ,
1

Hi,
I’m on Studio. I’ve a CSV with 10 columns and several rows. CSV has headers.
I’m reading this csv and storing in datatable (dt1). Then I build a table with 10 coulmns (dt2). I use "filter datatable’ to filter out csv based on Weight <=10. I store it in (dt3) as filtered data. I do for each row and then Add Data Row. I add row.ItemArray and store it in (dt2). Then I write range Excel.
Issue is dt2, dt3 the data tables (dt1 to dt3) are blank. What’s not correct ?

2

Hi,

Can you share your workflow as file?

Regards,

3

Hi,

Not sure about the Filter Table but alternatively you can try below code using assign activity also :slight_smile:
dt3.Select(“[Weight]<=‘10’”).CopyToDataTable()