User ID field showing User Name

Poorva Bhawsar
Mega Sage

Hi Community,

 

I have a custom table there i have one user id field which is a reference field and referring to sys_user table. But when i am importing demo data into that custom table, its showing user id as user name but i want to display user ids there instead of user names. I have created 4 attributes in this field but that too not working.

 

Please help me with this so that it can only populate user ids there.

 

Thanks.

1 ACCEPTED SOLUTION

I checked everything. To display value of user ids i need to set it display = true and it will impact all the tables where that field is being used. As a solution, i created 2 fields one is reference and other is string as i need this to join tables.

View solution in original post

4 REPLIES 4

vchaudhary0
Tera Contributor

It may be chance that you have not given proper reference to that field. Try to re-check the reference and if it is correct then go to SYS_USER table and check what is correct backend name of USER_ID field.

I checked everything. To display value of user ids i need to set it display = true and it will impact all the tables where that field is being used. As a solution, i created 2 fields one is reference and other is string as i need this to join tables.

Deepak Negi
Mega Sage
Mega Sage

Check your transform maps configurations.

or show us in screenshots how you are doing it

I already checked it. Shared the solution above. Thank you so much.