How can I insert an If condition to check if there are extra columns in a Data Table?

Help Activities
, ,
6

Hi @Greggy ,

If you do know the Column Names that are required before hand, You could store it as an Array of String and use it with DefaultView.ToTable() to preserve only the mentioned required columns.

For Example,Considering Name, ID, Place are the column names you would want to keep/Preserve, we could have the array initialised in the below manner :

columnsToKeep = {"Name","ID","Place"}

Now, we could use the below Expression to Filter for only the Required columns :

DT = DT.DefaultView.ToTable(false,columnsToKeep)

Here, DT is your Datatable variable.

1 Like