Question

4
Replies
1112
Views
AA924747 Member since 2017 14 posts
-
Posted: 3 years ago
Last activity: 3 years 1 month ago
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
Share this page LinkedIn