Data Table - To identify a third column and concatenate values if it exists

[KavipriyaMoorthy]

I use a data table and add the values in it to a dictionary for further use:

In my data table, the delimiter I have is a colon.

I am using a If statement to check if there are values available in the column 3, if there is a value to concatenate column 2 and Column 3 in the value part of the dictionary.

So far, I tried “Contains”, regex, etc… it did not work, it throws an error that it couldn’t find the column.

What condition should I use in the If statement?

[NIVED_NAMBIAR (NIVED N)]

Hi @KavipriyaMoorthy

while specifying column name did u use Column3 ?

[KavipriyaMoorthy]

I declared a int32 variable that loops. I use that.

[NIVED_NAMBIAR (NIVED N)]

Can u show the if condition used ?

[KavipriyaMoorthy]

[NIVED_NAMBIAR (NIVED N)]

Instead of that condition u can use like this

row(2).ToString<>“”

It implies that if the cell value under the 3rd column should not be empty

Regards

Nived N

Happy Automation