Append row (add column)

[Allison_Matthews]

I have a datatable which looks like the following:

FirstName      LastName      Birthday    Gender    JoinKey
John            Smith         031292       M
Katie           Smith         020195       F
John            Smith         051187       M

I would like the JoinKey column to contain a concatenation of the first three columns. (So if this was done in Excel, it would be something like “=A2&B2&C2” I’ve tried just about everything I can think of/find on the forums, but can’t figure out how to get the column to populate correctly

[pavanh003 (Pavan Harisha)]

Hi,

Try to use for loop and inside for loop use assign statement like row.item(“JoinKey”)= row.item(0).tostring+row.item(1).tostring+row.item(2).tostring.

Let us know if this helps.
Regards,
Pavan H

[ronanpeter]

dt.Rows(Dt.Rows.IndexOf(row)).Item(“ConcatenatedColumnName”)

That is the string that you place in a ForEach row activity.

Here is an example:

concat2.1.xaml (7.1 KB)

[Allison_Matthews]

This worked. Thanks!