Append row (add column)

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 :frowning:


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.
Pavan H

1 Like


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

Here is an example:

concat2.1.xaml (7.1 KB)

1 Like

This worked. Thanks! :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.