Remove multiple columns in datatable

Learn
1

Hi All
I want to delete multiple columns in data table.

Ex;- I have data table with three columns and i dont know exact column name but i know starting word of the column name. Like I want to remove data columns which contains “Red” word…

How i remove the data columns in data table?Pls help me

2

Use While (or DoWhile) activity to loop from dtDataTable.Columns.Count()-1 downto 0
If dtDataTable.Columns(i).ColumnName.Contains(“Red”) → remove it with Remove Data Column activity using ColumnIndex i