Check a column exists in a datatable or not

[kavya.s16]

Hi everyone,

My requirement is i extract a name from subject of the email and add to existing datatable using add data column activity after that i have some comparing between datatables , My issue is when there is no name in subject of the email i dont use add datacolumn activity , but when comparing it causes issue , saying column not found

Is there any way where i check if a particular column data exists for eg : i am checking row2(6) where ‘6’ column is not present

Thanks in advance

[shreyash_shirbhate]

@kavya.s16

the email and add to existing datatable using add data column activity after that i have some comparing between datatables , My issue is when there is no n

Hi Kavya,

Please check this.

Check if a value exists in particular column

Hi, how to check if a string value is available in one column of data table. Example , i want to search “uipath” is available in my my datatable named, dt1 in column “Name” The column in which i want to search has comma and space separated values like “Name” uipath, automationanwhere, blueprism I want to search in the column “Name” of above dt1 table that my variable “uipath” is available or not

It has solution.

[suraj.setty]

Hi @kavya.s16

If you know your column name try using the below statement in IF activity to identify if the column is present or not

In IF Statement use YourDTname.cloumns.contains(“CloumnName”).

Hope this helps,

Thanks.

[fernando_zuluaga]

hey,

if you are using index for your columns, you can check first the lenght of the column with yourDt.ColumnCount, else if you know the name on the column use Dt.Columns.Contains(“stringText”)

regards

[kavya.s16]

thank you it worked

[suraj.setty]

Glad that worked.