Table Transformer_Transform ID into Name for Multi User Picker field

[Hoang Nguyen]

Hello Community,

I'm building a Confluence dashboard by pulling Jira custom fields, and followed this thread here to merge 2 tables to transform ID into Name. But, it only worked on Single User Picker fields. I receive this error for Multi User Picker fields: 

TypeError: Cannot read properties of undefined (reading '[field name]')

Is there a way we could make it work for Multi User Picker fields? Thank you!

[Stiltsoft support]

Hi @Hoang Nguyen ,

If by the Multi User Picker field you mean not |user_a| but |user_a, user_b, user_c| (several user names in one cell divided by any separator, more likely by comma), then you may try to split them into separate rows.

Here is an example from our documentation (the "Splitting cell values in a column to different rows" section): https://docs.stiltsoft.com/tfac/dc-server/custom-transformation-use-cases-with-advanced-sql-queries-42241587.html#CustomTransformationusecaseswithadvancedSQLqueries-Splittingcellvaluesinacolumntodifferentrows

Then the JOIN function will be applied to your tables.

After all the manipulations your may group your result table back.

Also if you are stuck, you may refer to our support portal that is confidential. You'll be able to attach the screenshots of your tables and the page storage (upper right corner of the page -> menu ... -> View storage format). We'll recreate your page and help you with the case.