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
Accenture
IN
Not Sure If this is what you are in need of..
You can use a string utils concat function to give the key column input along with the other inputs (while adding records to lookup table)
Accenture
IN
if its fine to use another lookup table then it will make this simple. extract records one by one from current look up table or grid and add an extra column in the new look up table. Now concat the columns and make a new key column filled.(using add record method in the look up table)(if u add columns propetry in the look up table item u can see the add record method in the methods section)