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.