Skip to Content
Nov 30, 2020 at 01:15 PM

Obstruction in Concatenating Multiple Columns in a Single Column in IDM DB

63 Views Last edit Nov 30, 2020 at 01:18 PM 2 rev

Dear Experts,

We have a requirement wherein IdM is deriving the user-role assignment data from a custom table. We have configured a "From Custom" pass to read the data from custom table in GRC. However, hitting a roadblock wherein there is no unique identifier in that custom table. So, we are trying to concatenate multiple columns into one unique column in IdM DB so that all row values can be passed. Attaching screenshot of current configuration. Can someone please guide on how to pass multiple columns from a custom table into a single column in IdM DB.