Easiest way to delete all but 1 column from data table

Hi Everyone!

I have a data table that has about 100 columns on it, but I only need 1 of them. I want to delete the rest so I can easily remove duplicate rows. I know I can loop through and delete the columns, but I was hoping for a quicker way to do it.


with the filter datatable activity you can easy configure which column to keep / or which columns are to remove. the result can overwrite the initial DataTable or it outputs a new one


thanks @ppr I am going to give that a shot real quick!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.