Need data from split to be used in choice

Hi all,I got data from multiple choice and record in a cell called “machine”, e.g., “mc01,mc02,mc03”. And I tried to use split to separate these data for use with choice. But It doesn’t work out.
How can I separate these data and display in choice component?

You need to transpose the array into a list with a helper table.

2 Likes

Do those machine IDs already exist in another table? If so you can use the Split column to create a Relation to the machine table. Then source your choice component from the relation.

2 Likes

If you don’t have those machine IDs already in another table, then you can use AI component to create a custom choice component.

1 Like

Thank you. I will try.