I get a varying list of columns from a source and select these columns in my data table. The data table has many other columns, but I want to hide/exclude the columns which are not in the list provided to me while my script is running and doing some analysis...
I can select all the columns which I don't need by line below:
dt < <invert column selection (Provided_List)
Next step: Exclude these selected columns. How do I do that?
From scripting book, I can see column("X") << exclude(1) would exclude the column with name X, but is there a method to exclude already selected columns?