Write selective range

Hi @A_Learner

Way 1:

In Filter Data Table activity open the Configure Filter and give the respective column names you want keep within double quotes

and store the output in a new variable. Pass that data table variable in Write Range Workbook

Way 2:

You can below syntax also. It’s an linq query:

dt_Filtered = yourdatatable.defaultView.ToTable(False,"column name1", "column name2",......so on)

Give all your column names this will also work

Regards

1 Like