Question

4
Replies
1192
Views
A A (AA924747)
-

-
PH
AA924747 Member since 2017 14 posts
-
Posted: August 2, 2017
Last activity: August 3, 2017
Posted: 2 Aug 2017 9:29 EDT
Last activity: 3 Aug 2017 3:52 EDT
Closed

How to concatenate 2 columns in DataGrid/lookupTable and produce new column

Hi,

I would like to concatenate 2 columns to a new column to make the record unique:

Example: DataGrid has:

UserName | Group

aaa | GroupA

aaa | GroupB

Expected Result: Should create new column named "Key" below that will concatenate the 2 columns:

UserName | Group | Key

aaa | GroupA | aaaGroupA

aaa | GroupB | aaaGroupB

Just need this to populate lookupTable which only accepts unique key for 1 column.

Thanks

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.